SQL•SQL References

MS Access Str() Function

Example

SELECT
Str(42) AS ConvertToString;

Definition and Usage

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

Syntax

Str(
number
)

Parameter	Description
number	Required. The number to convert to a string

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

SELECT
Str(42) AS ConvertToString;

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

Syntax

Str(
number
)

Parameter	Description
number	Required. The number to convert to a string

Works in:	From Access 2000