Where clause

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I use a WHERE clause in a RecordSource Select statement to find all
values in a text field that START WITH a certain string, instead of just
being equal to a certain string?
 
Use the Like operator, with a trailing wildcard, e.g.:
WHERE Surname Like "D*"

If you have not downloaded this Search Form example yet:
http://allenbrowne.com/ser-62.html
it does demonstrate that capacity on the company/surname field.
 
You must log in or register to reply here.

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

Error: Compile Error,ByRef argument type mismatch 0
where clause 3
Clause order in SQL select query 5
DateDiff function throwing error in Where clause 7
Single WHERE and ORDER clause in UNION? 4
MS 2003 Parameterized Query 0
not in criteria fails 2
Data values contain Parentheses (N) with String inside 17

Back
Top