Remove spaces from both ends of a string.
| SELECT Trim(” SQL Tutorial “) AS TrimmedString; |
The Trim() function eliminates spaces from both the beginning and end of a string.
| Trim(string) |
|
Parameter |
Description |
|
string |
Required: The string from which leading and trailing spaces need to be removed. |
|
Works in: |
From Access 2000 |