kabir kabir

kabir kabir

  • 1.4k
  • 286
  • 935

Like Operation Sql Query

Feb 2 2018 11:31 PM
How to solve this for Bangla,Hindi,China,Japanee font
 
    No         Date         Ttile
18-0002-01   2018-01-25      ????? ???? ?????? ??? ??????? ???? ?????? ??? ?????? ?????? 
18-0003-01  2018-01-25      ???? ?? ?????? ?? ?????? ?? ???? ???? ??? ??? ??????
 
1st Problem :
 
SELECT No, Date, Title
FROM vpro.News
WHERE (Title LIKE N'%??????? %')
 
Output : 
 
   No         Date               Ttile 
NULL           NULL                   NULL 
 
2nd Problem:
 
how to difference 
 
WHERE (Title LIKE N'%??????? %') OR          // manual where condition
(Title LIKE '%??????? %')                                 // From UI  Come where condition
 
 

Answers (1)