RTRIM does not remove spaces at the end?

Question

I have used the Query:

    update Table
    set Seg = RTRIM(Seg)

This still doesn't remove the extra spaces at the end? I really need to remove this as I am doing vlookups in Excel and it is causing problems.

The datatype of Seg column is (nchar(10), null)

Any help is appreciated.

Maybe there is a hidden character (Char(13), Char(10)) at the end instead? — Mark Kram, Oct 23 '17 at 10:11
Take a peek at https://stackoverflow.com/questions/42958278/sql-server-search-using-like-while-ignoring-blank-spaces/42958939#42958939 — John Cappelletti, Oct 23 '17 at 10:17
yes Mark is correct, just tested..`create table #t ( col1 nchar(100) ) insert into #t select 'abc '+char(13)+Char(10) select col1,RTRIM(col1) from #t` — TheGameiswar, Oct 23 '17 at 10:19

score 1 · Answer 1 · answered Oct 23 '17 at 12:06

You can right-trim an NCHAR(X) column all you want, values will always be the same length. Namely: X. The value will always be padded with spaces, so RTRIM is basically a no-op on a fixed width character column.

Also note that in string comparisons, trailing spaces are ignored.

score -1 · Answer 2 · answered Oct 23 '17 at 10:35

-1

To trim spaces from the end you should use

UPDATE TableName SET ColumnName = RTRIM(ColumnName)

if you want to trim all spaces then use this

UPDATE TableName SET ColumnName = LTRIM(RTRIM(ColumnName))

answered Oct 23 '17 at 10:35

sanal sunny

1
1

RTRIM does not remove spaces at the end?

2 Answers2