Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    0

    Question Unanswered: is 'A-' less than 'A X' ?

    Hi,
    I'm using Sql Server 2000 Std ed. + SP3 which installed on Win XP.
    Regional settings is Turkish.

    use master
    select (case when 'A-'<'A X' then 'wrong result' else 'right result' end)
    go

    command gives an output like
    'wrong result'

    I used that command on DB2 7.2.
    Command is:
    values (case when 'A-'<'A X' then 'wrong result' else 'right result' end)
    It gives an output like
    'right result'

    Is this a bug? Or did I forget any params?
    Any help would be appriciated.
    Memduh

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    They are probably both correct, using different collations.

    -PatP

Posting Permissions

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