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 [EMAIL PROTECTED]
