Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

Str

Example

Convert a number into its string representation.

SELECT Str(42AS ConvertToString;

Definition and Usage

The Str() function converts a number into its string representation.

Syntax

Str(number)

Parameter Values

Parameter

Description

number

Required. Specifies the number that will be converted into a string.

Technical Details

Works in:

 From Access 2000