Str

Return a string representation of a number.

Syntax
      Str(Number)

Key
   Number  The number to return as a string.

The Str() function may be used in VBA or in an SQL query.

Examples

Dim strDemo as String
strDemo = Str(64)
'Returns: "64"

Select "Order Number " & Str([OrderID]) & " has been dispatched" from T_Orders;

“Empty pockets never held anyone back. Only empty heads and empty hearts can do that” ~ Norman Vincent Peale

Related:

Int - Return the integer portion of a number.


© Copyright SS64.com 1999-2013
Some rights reserved