Results 1 to 3 of 3

Thread: Trim

  1. #1
    Join Date
    Mar 2002
    Posts
    20

    Angry Unanswered: Trim

    Hi

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

    cheers

  2. #2
    Join Date
    Mar 2002
    Location
    India
    Posts
    7
    Hi,

    You can try using the rtrim function

    Regards

  3. #3
    Join Date
    Jan 2002
    Posts
    28
    Hi

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

    bye

    raju

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •