database

Not much to this one, and I don’t use access often, but it’s something that had me stumped for a little while so thought it worth posting. In (normal) SQL whenever you need to do a basic search in a field, the syntax is:

select * from exampletable where field1 like ('text%')

The % are used as the wild cards but not in Access!!! Read more…