| [ Web Proxy ] |
| Viewing: https://riptutorial.com/sql/example/3604/trim-empty-spaces | [Back] [Original] |
[logo rip]
Trim is used to remove write-space at the beginning or end of selection
In MSSQL there is no single TRIM()
SELECT LTRIM(' Hello ') --returns 'Hello '
SELECT RTRIM(' Hello ') --returns ' Hello'
SELECT LTRIM(RTRIM(' Hello ')) --returns 'Hello'
MySql and Oracle
SELECT TRIM(' Hello ') --returns 'Hello'
| Web Proxy Viewer | New URL | Original Page |
![[pdf]](https://riptutorial.com/Images/icon-pdf-2.png){kind=link}
![[logo rip]](https://riptutorial.com/Images/logo_rip_full_white.png){kind=link}