Essential Books

Trim empty spaces

suggest change

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'
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

String Functions:
*String Functions
*Concatenate
*Length
*Trim empty spaces
*Upper lower case
*Split
*Replace
*Stuff
*Substring
*REGEXP
*LEFT - RIGHT
*REVERSE
*REPLICATE
*Replace function in sql Select and Update query
*PARSENAME
*INSTR
Table Of Contents