Hi
I have the following two queries:
1) select count(*) from mappings where substring(virtual from 1 for 1) = '@';
2) select count(*) from mappings where virtual like '@%';
both should do the same thing - give me a count of virtual which starts with '@'.
however, the results returned are different
Statement 1 returns 12
Statement 2 returns 2623
Is there an error in my tables? If so, how would I fix it?
Regards
--
Chris Picton
Usko Communications Systems Developer
Chris.Picton@usko.com
