rtrim issues

[bouwob]

ok I seem to be having troubles using rtrim and ltrim.

I have this sql

update table set description = lTRIM(rTRIM(description))

which should cut off the beginning and trailing white spaces but when I run

select distinct(description) from table order by description

after the trims

I get many results that look like this

'WRQ'
'WRQ '
'WRQ '

what is the deal?

tia

 

[gmmastros]

RTrim will not remove 'non-printable' characters, like TAB, CR, LF.

Try this...

update table set description = Replace(description, Char(9), '')

update table set description = Replace(description, Char(10), '')

update table set description = Replace(description, Char(13), '')

As always with update statements, make sure you have a good backup before running this.

-George

"the screen with the little boxes in the window." - Moron

 

[AlexCuse]

what about this?

update table set description = replace(description, ' ', '')

This will replace any spaces in description with '' (nothing).

Hope this helps,

Alex

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[bouwob]

man gmmastros you are on the ball today. Didnt even think about non "space" white spaces.

thanks alot.

AlexCuse

Had that thought but I just needed to remove starting and trailing spaces. And not spaces within the description. Thanks for the insight though.

 

[gmmastros]

Glad I could help.

-George

"the screen with the little boxes in the window." - Moron

 

[AlexCuse]

>>>man gmmastros you are on the ball today.

So that means it must be a day

sorry about that, I didn't realize you could have spaces in the description. And I still don't think it would handle tabs, cr's or lf's.





[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom