|
Syntax |
TRIM(Text) |
|
Description |
Returns the supplied text, stripped of all leading and training spaces, tabs and newline characters. |
|
Example |
TRIM (" 12 ") => 12 |
|
Text |
String to remove leading and trailing spaces, tabs and newline characters from. |
This function removes extra spacing in a combination of variables (for example, when the database has set a defined number of characters for each particular database field or when a database field is left empty).
TRIM removes any extra spacing at the left and at the right side of the word in the database field that has been selected.