Function | Usage |
---|---|
AlNum | Cab be used to check if the given string has alphanumeric characters |
Alpha | TRUE if string is completely alphabetic |
CompactWhiteSpace | all consective whitespace will be reduced to single space |
Compare | Compares two strings for sort |
ComparNoCase | Compare two strings irrespective of Case in-sensitiveness |
ComparNum | Compare the first n characters of the two strings |
CompareNumNoCase | Compare first n characters of the two strings irrespective of case in-sensitiveness |
Convert | Replace character in a string with the given character. |
Count | Count number of times a given substring occurs in a string |
Dcount | Returns count of delimited fields in a string |
DownCase | Change all uppercase letters in a string to lowercase |
DQuote | Enclose a string in double quotation marks |
Field | Return 1 or more delimited substrings |
Index | Find starting character position of substring |
Left | Finds leftmost n characters of string |
Len | Length of the string or total number of characters in a string |
Num | Return 1 if string can be converted to a number |
PadString | Return the string padded with the optional pad character and optional length |
Right | Finds Rightmost n characters of string |
Soundex | Returns a string which identifies a set of words that are phonetically similar |
Space | Return a string of N space characters |
Squote | Covers a string into single quotation marks |
Str | Repeat a string |
StripWhiteSpace | Return the string after removing all whitespace |
Trim | Remove all leading and trailing spaces and tabs. Also reduce the internal occurrences of spaces and tabs into one. |
TrimB | Remove all trailing spaces and tabs |
TrimF | Remove all leading spaces and tabs |
Trim | Returns a string with leading and trailing whitespace removed |
Upcase | Change all lowercase letters in a string to uppercase |
RS SEO Glasgow, 272 Bath St, Glasgow G2 4JR, 07460397220, rsseoglasgow . com