- If a string begins or ends with spaces, tabs, or other non-visible characters, they are removed by this function.
TRIMfunction does not remove whitespace between non-whitespace values, such as spaces between words. To remove that type of whitespace, use
REMOVEWHITESPACE. See REMOVEWHITESPACE Function.
TRIMfunction can be used with the
TRIMQUOTESfunction, which removes leading and trailing single- and double-quotes. For more information, see TRIMQUOTES Function.
|D s lang vs sql|