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 :: SubString
Returns length characters of the value, starting at the zero-based startIndex.
SQL :: Syntax
Basic KBSQL syntax and some examples.
SQL :: ToLower
Returns the value converted to lower case.
SQL :: ToNumeric
Returns the value converted to a number.
SQL :: ToProper
Returns the value with the first letter of each word capitalized (title case).
SQL :: ToString
Returns the number as a string, so that + concatenates it instead of adding it.
SQL :: ToUpper
Returns the value converted to upper case.