escape characters in Access

[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

 

[Ken Snell]

Instead of using
Like "*"

use
Like "[*]"

 

[Darren \(at work\)]

Got it.

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