Classic ASP Discussion

Print Page | Close Window

SQL search

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=2157
Printed Date: 29 March 2026 at 6:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL search

Posted By: the boss
Subject: SQL search
Date Posted: 26 April 2003 at 6:50am

im an searching into a database coloumb using the LIKE opreator of sql.. from a web page..is there any other opreator which i can use to search in a better way bcuz the LIKE opreator returns results which are starting with the keyword provied for search...if that keyword is present in the mid of the word.. it doesnt returns that in search results...in simple words..i want to persom full text search :)

Replies:

Posted By: michael
Date Posted: 26 April 2003 at 9:15am

SQL Server has Full Text Search capabilities thus needs to be installed and configured. I don't think lots of hosts will offer that for you. THough if you want the LIKE operator to return instrings just go like ..... where whatever LIKE '%keyword%' .... this way it does find it if the keyword is in the middle.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: the boss
Date Posted: 27 April 2003 at 2:32am

full text search is already installed and configured ... the SQL database is located locally on my computer.. i am running SQL server personal edition

Posted By: Bunce
Date Posted: 27 April 2003 at 9:35pm

As Michael said LIKE '%keyword%' will solve your problem.

(As an aside, you can also use the SOUNDEX function to do a 'Sounds Like' comparison)

Cheers,
Andrew

-------------
There have been many, many posts made throughout the world...
This was one of them.