Results 1 to 5 of 5

Thread: Rtrim

  1. #1
    Join Date
    Oct 2005
    Posts
    58

    Unanswered: Rtrim

    If Rtrim doesn't catch space at the end is there a way to catch strings that match but don't seem to get selected correctly when matching?

  2. #2
    Join Date
    Dec 2004
    Location
    California, USA
    Posts
    93
    Um, what do you mean by "Rtrim doesn't catch space at the end"? Or by "catch strings that match but don't seem to get selected correctly when matching"?
    Whoever imagines himself a favorite with God holds others in contempt. - Robert Green Ingersoll, lawyer and orator (1833-1899)

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Some sample data and some code would be helpfull.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jul 2003
    Posts
    50
    Is it possible there is some unwriteable chars there? Ie ASCII below 32?

    I don't if the show up or not in SQL-Server, just related to C++ programming where unwriteable chars can mess up things.

  5. #5
    Join Date
    Jul 2003
    Posts
    50
    use this to check if the last char really is a space...

    SELECT
    ASCII(SUBSTRING(yourcolumnname, len(yourcolumnname), 1))
    FROM yourtable

Posting Permissions

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