Access 2000 Simple Query - TechRepublic
General discussion
September 4, 2003 at 09:02 AM
mra2

Access 2000 Simple Query

by mra2 . Updated 22 years, 10 months ago

I imported a database written in some other database product. There is a field called code.
Some of the typical entries are:
* *T * S T S

I’ve tried to get the query to find the * entries or the *T or *S entries. But access keeps presuming that the * is a like clause and gets the wrong records.

I’ve already tried Single quotes and double quotes with NO SUCCESS.

Any help you can offer would be greatly appreciated!

Thanks,
Alan

This discussion is locked

All Comments