Searching a field for a text string

[Steve Welman]

Hi

Is there a function whereby I can saearch a text string in a field for a
certain character, similiar to the excel find function?

I have a field in the table consisting of policy numbers, occasionaly these
numbers will have a slash in them, I need to determine which records have /
in them and stop processing them, how do I go about this?

Regards

Steve

 

[John Spencer]

Try the INSTR function.

 

[Nick Coe \(UK\)]

InStr() should do the trick for you. The help explains it's
use quite well.

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store
http://www.mrcomputersltd.com/ Repairs Upgrades

In Steve Welman typed:

 

[Marshall Barton]

Is there a function whereby I can saearch a text string in a field for a
certain character, similiar to the excel find function?

I have a field in the table consisting of policy numbers, occasionaly these
numbers will have a slash in them, I need to determine which records have /
in them and stop processing them, how do I go about this?

If all you want is to check if the field contains a / then
it might be more intuitive to use the Like operator. E.g.
In the field's criteria in a query:
Not Like "*/*"