grouped IIF statement to search for specific words in a field

[Tupence]

I have a list of company names that i want to write a grouped IIF statement to bring back results of only those with Limited, LTD or plc. in the field, these are always at the end of the string, I have thought about using RIGHT function but I have also found the Instr function but don't know how it works or if this is right for the job.

Any help would be appreciated.

 

[Golom]

You could use the LIKE keyword

WHERE myField LIKE '*plc' or myField LIKE '*LTD'

 

[Tupence]

i have checked the MS access functions and this one doesn't appear.

Any other suggestions? thanks.

 

[MajP]

You are in the Query forum. So this is a Sql command:

http://www.techonthenet.com/access/queries/like.php

 

[Tupence]

Sorry, novice mistake! ha ha