Trailing spaces when converting from CHAR to VARTCHAR

[Nordlund]

Hi there.

This might be a simple question, but lack of time does the problem.

How do I remove the trailing spaces when I'm converting CHAR-fields to VARCHAr-fields.

We are talking about 150 tables and about 5-20 CHAR-fields in each table.



//Nordlund

 

[JayKusch]

Hmmm ...

maybe something like ...

Set NewVarCharField = RTRIM(LTRIM(CharField))

Thanks

J. Kusch

 

[Nordlund]

Hi.
Thanks for the answer, Kusch...
I did a doublepost, look at:

http://www.tek-tips.com/viewthread.cfm?SQID=872125&SPID=183&page=1

//Nordlund