select query like doesnt work for....

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

select query like doesnt work for....

Author

Topic

asifbhura
Posting Yak Master

165 Posts

Posted - 2010-03-21 : 17:07:37

Hi,

I have select query as below

but it doesnt work for arabic text

SELECT * FROM PostNews WHere News_Title like '%????%'

news_title column is nvarchar(500)

and it has value same as in query.

please why it is not working

Regards,
ASIF

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-03-21 : 17:15:16

Implicit conversion. Use unicode in your search string by adding N in front if it.

SELECT * FROM PostNews WHere News_Title like N'%????%'

N 56°04'39.26"
E 12°55'05.63"

asifbhura
Posting Yak Master

165 Posts

Posted - 2010-03-21 : 17:57:03

thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources