My ASP Search page criteria is dynamically created using WhereClause's after selecting options from a form page.<BR><BR>"SELECT * FROM [Jobs] WHERE JobType = 'Contract' AND Skills LIKE '%C%' AND InStr(Location,', NH')>0 ORDER BY Date DESC, Title ASC " <BR><BR>In this statement it would bring up every record that has the letter "C" in the "Skills" field of an Access database instead of consultants with the "C" programming language, so I think I need to use regular expressions to control exactly what the user is looking for when they search on single characters. <BR><BR>How do I use regular expressions with an SQL query to build a SQL statement that would eliminate jobs like "Visual Basic" or "Cobol" or any word which has the letter c in it? <BR><BR>Can regular expressions be used with SQL? Is there any articles that could help me? I cannot use the New RegExp object by itself since there is other criteria to search on besides looking in one field.(SQL statement)<BR><BR>Below is the end of code on my ASP Search page: <BR><BR>Query = "SELECT * FROM [Jobs] " & WhereClause & _ <BR>"ORDER BY Date DESC, Title ASC" <BR><BR>Set Jobs = Connect.Execute(Query) <BR><BR>Signed, <BR>Puzzled?