 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / October 2007search in web site
hi i want the sql script of search in a field of database of course i've written this scipt but in Unicode search it dosen't work select * from Table1 where tex like '%" + Request.QueryString["search"].ToString() + "%' or topic like '%" + Request.QueryString["search"].ToString() + "%' thanks % in sql means match more than one word. select * from Table1 where tex like '[%]" + Request.QueryString["search"].ToString() + "[%]' or topic like '[%]" + Request.QueryString["search"].ToString() + "[%]' try it! > hi > i want the sql script of search in a field of database [quoted text clipped - 5 lines] > > thanks On Oct 5, 2:45 pm, "miladha...@gmail.com" <miladha...@gmail.com> wrote: > hi > i want the sql script of search in a field of database [quoted text clipped - 5 lines] > > thanks Have you tried to create a full text catalog on the field you wish to search on, this may allow you unicode searches. You can create these via enterprise manager on the database node, it is then just up to you to implement the full text search on the programming side which is very simple :)
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.