Search function

  • Thread starter Thread starter Samuel Shulman
  • Start date Start date
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
 
Use LIKE "*" & Forms!MyForm!MyTextBox & "*"
Assuming the criteria is entered on a form.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Specific Characters From Text 1
Query Criteria not filtering out correctly 5
Passing Function values to a Query 6
Queries--concatenate or merge records (not fields) 1
Displaying partial value in query results 3
Query To Define Outstanding Issued Document 2
Validate input field to filter out certain characters 3
Assistance with calling UDF from a query 6

Back
Top