|
| KiXtart Command Reference |
SUBSTRactionreturns part of a string. syntaxSUBSTR ("string", start, length) parametersString The string from which to extract a substring. Start Numeric value representing the offset in the string where the substring begins. Length Numeric value representing the length of the substring. returnsThe substring indicated by start and length. example$x = SUBSTR(@USERID, LEN(@USERID) - 2, 2) ; get the last 2 chars of the userid |