Home [SQL] 操作字串 (刪除空白 Ltrim、Rtrim)
Post
Cancel

[SQL] 操作字串 (刪除空白 Ltrim、Rtrim)

Posted Apr 11, 2011
By R
1 min read

Ltrim

刪除前面的空白

1

SELECT LTRIM('  AAA');

Rtrim

刪除後面的空白

1

SELECT RTRIM('AAA   ');

MSDN - RTRIM (Transact-SQL)
MSDN - LTRIM (Transact-SQL)

Notes, SQL
sql string ltrim rtrim
This post is licensed under CC BY 4.0 by the author.
Contents