escape characters in Access

  • Thread starter Thread starter Darren \(at work\)
  • Start date Start date
D

Darren \(at work\)

Hi,
I am trying to write an SQL string that will search for all entries in a
text column that begin with the * (asterisk) character. can someone tell me
what the escape character is that I can use to achieve this, as at teh
minute the query returns ALL entries, as I expected. Current SQL is:

===== Being Code ======================

SELECT parts_inspected.[Item No], itemlist.[Item Name], itemlist.[Item
Description], parts_inspected.Inspector
FROM itemlist INNER JOIN parts_inspected ON itemlist.[Item No] =
parts_inspected.[Item No]
WHERE (((itemlist.[Item Description]) Like "*") AND
((parts_inspected.Inspector)="Keith Foster" Or
(parts_inspected.Inspector)="Colin Pennie"));

===== End Code =======================

I am using Access 2002.

Regards
Darren
 
Got it.

Instead of:
=============
Like "*"
=============
I used
=============
Like "[*]*"
=============
Works a treat
 
Back
Top