query for ***

[rothjm]

I have a table with Patient names.
If the patient is deceased, they put *** after their name.
Not sure who the bonehead that thought of that is.
Anyway, I want to create a list of those for deletion.
I'm having trouble with my query.
Three columns: Patient Number, Last Name, First Name
Example of what it looks like:
000001 Duck Daffey ***
There's a space and three *'s after the first name.
I'm trying to do a simple query in Access 2000.
What would be my criteria to pull all those with " ***" after the first name?
I tried everything I could think of. Single quotes, double quotes etc.
Thanks for the assistance!

 

[SQL_Hell]

the '*' is SQLs way of saying it wants all records. So using *** was an incredibly bad thing to do.

How many records do you have? You might have to manually change these.

 

[Jon K]

You can use the criteria:-

Like "*[*]"
.

 

[rothjm]

Thanks a ton Jon K!
That worked for me!

I know it was a horrible standard to use....the users weren't very knowledgeable.

You guys are great!

 

[KenHigg]

Like "*[*]" = cool. How do you look that up in help?

kh