Str

Return a string representation of a number.

Syntax
      Str(Number)

Key
   Number  The number to return as a string.

The Str() function can 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 © 1999-2021 SS64.com
Some rights reserved