Trim

Table of Contents



Removes white space from the start and end of the value. When characters is given, each of those characters is removed from the start and end instead.

String Trim(String text, String characters = null)

round-pushpin Returns 'hi' twice.
SELECT Trim('   hi   ') as Spaces, Trim('--hi--', '-') as Dashes FROM Single




SQL :: IsDouble
Returns true (1) if the given value can be converted to a decimal number.
SQL :: IsEmpty
Returns true (1) if the given value is null or an empty string.
SQL :: IsEqual
Returns true (1) if the two given values are equal. The comparison is case-sensitive.
SQL :: IsGreater
Returns true (1) if the first value is greater than the second.
SQL :: IsGreaterOrEqual
Returns true (1) if the first value is greater than or equal to the second.
SQL :: IsInteger
Returns true (1) if the given value is a whole number, with an optional leading sign.
SQL :: IsLess
Returns true (1) if the first value is less than the second.
SQL :: IsLessOrEqual
Returns true (1) if the first value is less than or equal to the second.
SQL :: IsLike
Returns true (1) if the text matches the pattern. The pattern uses the same wildcards as Like: % matches any number of characters and _ matches a single character.
SQL :: IsNotBetween
Returns true (1) if the value is outside of the given range. The range boundaries are considered inside the range.