Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013
    Posts
    5

    Unanswered: Please explain this query

    Hi All,
    I have a query like below

    select col1, col2 from table1 where col1 > ' '
    -- Six space inside the quotes
    Here col1 is char(6) column, what is the use of this?

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    This will generally exclude rows where col1 start with a space,tab,newline,etc. (e.g. > 32nd ascii char) depending on your character set and sort order

Posting Permissions

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