Delete Records Where The Like* Can Be used??

[Bateman28]

Hi

I am trying to use a delete query where any records that contain the Word
Proprietor is removed. In My current table there are hundreds of records
within a "Customer Name" field where the names are for example:

Mr T Proprietor
Mr D Proprietor
Mr C Proprietor

I Would like to delete all of the records that contain the word "Proprietor"
as these are records that are not used. I have tried a Like "Proprietor*"
Query But this didn't work. If anyone could help it would be great

Cheers

 

[Krzysztof Naworyta]

Juzer Bateman28 <[email protected]> napisaÅ‚
| Hi
|
| I am trying to use a delete query where any records that contain the
| Word Proprietor is removed. In My current table there are hundreds of
| records within a "Customer Name" field where the names are for example:
|
| Mr T Proprietor
| Mr D Proprietor
| Mr C Proprietor
|
| I Would like to delete all of the records that contain the word
| "Proprietor" as these are records that are not used. I have tried a
| Like "Proprietor*" Query But this didn't work. If anyone could help it
| would be great


Like "Proprietor*"
if you want to delete every record with field that STARTS with
"Proprietor"

Like "*Proprietor"
if you want to delete every record with field that ENDS with "Proprietor"

Like "*Proprietor*"
if you want to delete every record with field that contains "Proprietor"

 

[Petr Danes]

The phrase Like "Proprietor*" selects only those records where the word
Proprietor is at the beginning of the field.

If you want all records that contain the word Proprietor at the end of the
field, use Like "*Proprietor".

If you want all records that contain the word Proprietor anywhere in the
field, use Like "*Proprietor*".

Pete

 

[Bateman28]

Thanks to both of you for the quick response, i had a feeling i was being
stupid, thats great

Cheers