Home Forums SQL Server 2008 SQL Server 2008 Administration Data Issue RE: Data Issue

  • March 6, 2013 at 7:41 am

    #1593965

    Ratheesh.K.Nair (3/6/2013)

    Thanks Chris for the reply.

    Problem i am facing is When selecting I am getting same data while using symbol F or F as search criteria both are giving the same result.

    SELECT

    Descript,

    MyString,

    p2 = UNICODE(SUBSTRING(MyString,2,1))

    FROM (

    SELECT Descript = 'Normal Latin F', MyString = CAST(N'4F' AS NVARCHAR(2)) UNION ALL

    SELECT Descript = 'Wide Latin F', N'4F'

    ) d

    --WHERE MyString = '4F' -- need a width-sensitive collation here

    WHERE MyString = N'4F' -- need a width-sensitive collation here

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden