Need Help with Looping Search 1

[JonWolgamuth]

I am looking for a way to search a field on a table for a special character. I want to identify each record which has a comma embedded. I have tens of thousands of records to search through.

I did a keyword search, but am having difficulty since I don't know what keywords to search for.

Any help will be greatly appreciated!

 

[mpastore]

select myfield from mytable where instr([myfield],",&quot>0

 

[JonWolgamuth]

mpastore,

Thanks for the quick reply. After some searching, I wondered if instr might work, but didn't know exactly how to put it together.

I'll let you know how it works. Thanks again!

Jon