Extract and Format Strings
Modifications to the extracted values are made for the purposes of the query only. The actual data stored in the target source is not changed in any way.
Replaces all occurrences of a string in a target with a specified string.
Converts all of the characters in a string to lower case for the purpose of performing a query.
Converts all the characters of a string to upper case for the purpose of performing a query.
Removes leading and trailing white space, tabs and linefeed characters from a string.
Converts the first letter of a string to upper case.
Converts the first letter of every word in a string to upper case.
Concatenates the specified string values.
Converts a target string or value into a date data type.
Encodes the specified object as a URL.
Encodes the specified object as a URL using the specified character set.