Evaluating Numeric Data as Strings

In the same way that numbers in quotes will be interpreted as numeric values when used in logical calculations, numeric values will be interpreted as strings when included in string-based functions.

For example:

StrLen(4329) = 4;
Concat( "User", ( 4 * 4 ) ) = "User16";
SubStr( 123456789, 3, 4 ) = "4567";

Because of this, you do not need to put a numeric value in quotes when you want to analyse it as a string.

 

<< Previous: Selective Trim (LTrim and RTrim) | Next: Lesson Summary >>