PDA

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;)