SQL•SQL References

MS Access Str() Function

Concept visual

MS Access Str() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return a number as a string:

Select

Str(42) AS ConvertToString;

Definition and Usage

The Str() function returns a number as a string.

Syntax

Str(

number )

Parameter Values

Parameter

Description number

Required. The number to convert to a string

Technical Details

Works in:

From Access 2000

MS Access Str() Function

Concept visual

MS Access Str() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return a number as a string:

Select

Str(42) AS ConvertToString;

Definition and Usage

The Str() function returns a number as a string.

Syntax

Str(

number )

Parameter Values

Parameter

Description number

Required. The number to convert to a string

MS Access Str() Function

MS Access Str() Function

Example

Select

Definition and Usage

Syntax

Str(

Parameter Values

Parameter

Description number

Technical Details

Works in:

From Access 2000

Previous

Next

MS Access Str() Function

MS Access Str() Function

Example

Select

Definition and Usage

Syntax

Str(

Parameter Values

Parameter

Description number

Technical Details

Works in:

From Access 2000

Previous

Next