Delete Records Where The Like* Can Be used??

  • Thread starter Thread starter Bateman28
  • Start date Start date
B

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
 
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"
 
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
 
Thanks to both of you for the quick response, i had a feeling i was being
stupid, thats great

Cheers
 
Back
Top