Finding the position of a character in a field

[RevJeff]

I am trying to find the position of a "," in a data field.

I was trying the SEARCH function I found in Help "SEARCH(',',[emplname])", but I am getting "Undefined function 'SEARCH' in expression." when I run the query.

Any ideas?

Thanks,
Jeff

 

[Alc]

Try the Instr function.

 

[boblarson]

check out the Instr function.

 

[ajetrumpet]

I am trying to find the position of a "," in a data field.

Instr() is a good thing to use for this....

Instr([start position of the search], [searched string], [","])

 

[RevJeff]

Thanks for the help. That worked great.