Search function

S

Samuel Shulman

Hi

I need to search fields in the database that contain certain a given string
ie if the user enter ABC and the field content is 'ABCD' the record should
then return

Thank you,
Samuel
 
K

Klatuu

Use LIKE "*" & Forms!MyForm!MyTextBox & "*"
Assuming the criteria is entered on a form.
 
S

Samuel Shulman

Thank you

Just btw, what is the difference between % and * (I used %)

Samuel
 
K

Klatuu

If I am not mistaken, % is a wildcard character for SQL Server and some other
database engines and * is for Jet, but I am not positive this is correct.
 
Top