Hi!
You should not run between for the character strings you specified with '%'-like characters. These special characters are processed only by the LIKE operator. I proposed the solution, but seems you did not read my letter carefully. Read it again. You can do this by separate selecting of the counds using LIKE operator. Than you can use selected results in the between operator/function.
>I ran some tests on between() and it didn't seem to work properly on char's. It seem to be now though.(?)
>
>thanks
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.