>I had only used found with seek. it occurred to me in the middle of the night last night that I should be able to use it with locate.
>thanks dragan - for the pointers.
>
In the first case you should have used SEEK function. FOUND() makes sense with LOCATE.
If it's not broken, fix it until it is.
My Blog