searching/parsing

[TheConeHead]

I want to have a page that searches a particular column in a sql 7 DB for say like a keyword.... any guidance on this?

 

[snowboardr]

look up the sql 'like' function www.vzio.com
ASP WEB DEVELOPMENT

 

[Gorkem]

Hey ConeHead,

You can use several different search types. The most widely used is the LIKE function

ie:

SELECT * FORM someTable WHERE Keywords LIKE '%keyword%'

but there are other methods for searching and matching.. I generally use both the LIKE and the SOUNDS LIKE functions such as SOUNDEX and DIFFERENCE.

SOUNDEX and DIFFERENCE are very useful if spelling may be an issue. Since many people may spell certain words (such as first/last names, cities, and such) differently, SOUNDEX and DIFFERENCE can match, for example, "BRIAN" with "BRYAN".

Here is an example SOUNDEX/DIFFERENCE SQL statement:

cmd.commandtext = "SELECT * FORM someTable WHERE DIFFERENCE(keyword, '" & request.form("keyword&quot & "') => 3 or Keyword LIKE '%" & request.form("Keyword&quot & "%'"

The Difference will return a a value ranging from 0 to 4.. 4 being the highest possible match meaning it is exactly the same and 0 meaning it does not match at all. What we are doing in the above search is looking for anything that ranks a 3 or higher. This brings back a fairly accurate match.

Hope this helps,

Cheers,

Gorkem.