String functions
The string functions may apply on one or two selected fields from the grid of the Columns pane. We list these functions next (again, we only specify the MS-SQL Server version of the interpretation of the functions):
Option name in the popup list |
Inserted string (where Fld is the selected field) |
CharIndex |
CHARINDEX(sSearchFor, Fld, nPos) |
Difference |
DIFFERENCE(Fld1, Fld2) |
Left |
LEFT(Fld, nLen) |
Length |
LEN(Fld) |
Lower |
LOWER(Fld) |
LTrim |
LTRIM(Fld) |
PatIndex |
PATINDEX(sPattern, Fld) |
Replace |
REPLACE(Fld, sSearchFor, sReplace) |
QuoteName |
QUOTENAME(Fld,']') |
LeftPad |
REPLICATE(' ', nLen-LEN(Fld))+Fld |
RightPad |
Fld+REPLICATE(' ', nLen-LEN(Fld)) |
Reverse |
REVERSE(Fld) |
Right |
RIGHT(Fld, nLen) |
RTrim |
RTRIM(Fld) |
Soundex |
SOUNDEX(Fld) |
Space |
SPACE(nLen) |
Str |
STR(Fld, nLen, nDecimal) |
Stuff |
STUFF(Fld, nStart, nLen, sStuffWith) |
SubString |
SUBSTRING(Fld, nStart, nLen) |
Trim |
LTRIM(RTRIM(Fld)) |
Upper |
UPPER(Fld) |