Post reply

where syntax

  • July 16, 2011 at 2:24 pm

    #244233

    hi everybody,

    can I ask why i dint get any result from this query

    SELECT title

    FROM dbo.tblsubjects

    WHERE (title LIKE '%یه‌كگرتوی ئیڤچ%')

    Any help?

  • July 16, 2011 at 2:52 pm

    #1353881

    Because there was no match?

    We can't see what you see nor do we have the data available you're testing against.

    But most probably it is cause by the non-unicode data type you used in your query.

    Try

    SELECT title

    FROM dbo.tblsubjects

    WHERE (title LIKE N'%????????? ????%')


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • July 16, 2011 at 3:45 pm

    #1353889

    thanks you right the problem is solved i never forget your help .

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply