select with and

[Pamela Whittaker]

I have a select statement with and AND = in it.


and field = "audit_preparedby"

That doesn't find anything even though the field contains 'audit_preparedby'



and field like "%preparedby" works ok


and field like "audit%" doesn't find anything


I am puzzled. Any idea why audit_ is causing a probelm in a = ?



It seems to be any field starting audit_


Thanks