Trim [Archive] - dBforums

View Full Version : Trim

kop

03-09-02, 10:40

Hi

How do I trim a field of trailing spaces in SQL statement?

cheers:rolleyes:

suchetan

03-09-02, 14:10

Hi,

You can try using the rtrim function

Regards

raju

03-10-02, 23:03

Hi

Try to use ltrim(rtrim(xx)) to get rid of spaces...

bye

raju;)