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 :: NullWhen
Returns null when the value equals compareToValue, otherwise returns the value.
SQL :: NullWhenNumeric
Returns null when the number equals compareToValue, otherwise returns the number.
SQL :: Pow
Returns x raised to the power of y.
SQL :: Right
Returns the given number of characters from the end of the value.
SQL :: Round
Rounds a number to the given number of decimal places. Midpoint values are rounded to the nearest even number (2.5 rounds to 2).
SQL :: Scalar Functions
Scalar functions are evaluated once per row.
SQL :: Sha1
Returns the SHA-1 hash of the value's UTF-8 bytes as a lower case hex string.
SQL :: Sha256
Returns the SHA-256 hash of the value's UTF-8 bytes as a lower case hex string.
SQL :: Sha512
Returns the SHA-512 hash of the value's UTF-8 bytes as a lower case hex string.
SQL :: ShowScalarFunctions
Lists the built-in scalar functions with their parameters and descriptions.