>Hi Naomi
>
>I was talking about this on the tek-tips forums yesterday. LIKE() is not ANSI SQL. Use it in VFP where you need to, but in all SQLs use LIKE. Same goes for BETWEEN. In this case SQL LIKE does not accept question marks, but _. Personally, I find it really confusing to mix VFP and SQL syntax in a SQL command.
>
Thanks, Mike. I use SQL Like, I also check my date range control and switch to BETWEEN operator if I'm using function becuase I want to make my queries SQL compatible if possible.
If it's not broken, fix it until it is.
My Blog