I am trying to execute a select statement in Access 2000. I need to know how to use
wildcard's in the statement. I thought you used the * for a wildcard in the LIKE clause but apparently not.
My SQL statement looks like this:
SELECT * FROM [Table] WHERE [Table].[Field] LIKE *
The problem is in the LIKE part of the statement. I need to know how use LIKE to find anything (wildcard) in the particular field.
Thanks for any help!!!

Kris
Software Engineer
Phoenix,AZ