Where clause

Guest · Jul 21, 2006

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?

Allen Browne · Jul 21, 2006

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.

Where clause

Guest

Allen Browne