Search for a word or phrase using sql statement

[zl]

Hello:
How do you write an sql statement to search for a word or phrase in an ASP application? Thank you.

 

[vasah20]

can you elaborate more on what exactly you're trying to do?

eg: are you searching your DB, or all the ASP files that you have, or a combination of the two?

 

[Telsa]

You mean in the database?

Something like this...

SELECT ProdNum, Title
FROM SWprods
WHERE (((Title) Like "*4100*&quot);

This will search for all instances of 4100 in the Title no matter what part of the title it is in. Mary

Rule 1: Don't sweat the small stuff.
Rule 2: EVERYTHING is small stuff!! X-)