Wildcard Help!

N

nick dj

i have a table with a select query, one of the columns has data for example
the reference ab1234a or ba1234d, i am wanting to filter and only show the
items that begin with the first letter A but as the query also has the letter
a in the reference at another point it is extracting these entries as well,
where i am only interested in the items that begin with the letter a

any help greatly appreciated
 
K

Klein-4

i have a table with a select query, one of the columns has data for example
the reference ab1234a or ba1234d, i am wanting to filter and only show the
items that begin with the first letter A but as the query also has the letter
a in the reference at another point it is extracting these entries as well,
where i am only interested in the items that begin with the letter a

any help greatly appreciated
Click to expand...

If you use the criteria -- Like "A*" -- that should do it.

Ross La Haye
 
Top