Searching a Database for a Keyword

Question:

When setting up a recordset, is it possible to get a record when the field contains more than the word that I’m looking for and where the words are in no particular order?

For example:

StrName = 'Direct'	RSShops = Server.CreateObject("ADODB.Recordset")	strSql = "SELECT * FROM Shops WHERE Name =         '" & StrName & "'

Can I get the recordset to contain any shop/company with ‘direct’ in it’s name?

Answer:

Instead of using the Equal to (=) operator, use the LIKE operator in your SQL Statement.

To hunt for Shops with names that have the word ‘direct’ in them, your SQL statement would look like this:

SELECT * FROM Shops WHERE Name LIKE '%direct%'

You can thus modify your code accordingly.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: