My apologies, I meant to say that I am using Access 2003
I am using it in SQL query, probably that is again my mistake.
Need guidance on how to use it.
Thanks


"chinky" wrote:

I want to count number of '.' (dots) in an expression e,g. asd.rty.de.com
(answer = 3 dots at positions 4,8,11 respectively) . Instr functions gives
only the first occurrence.
Any help is appreciated
Thanks
Anupam