query

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 1

use charindex(' ',<email_address>). Returns non zero if a space or zero if no space.

Jeremy

Edited by - Jeremy Kemp on 04/10/2003 07:11:42 AM

bruce_reid SSCrazy Points: 2419 More actions · Answer 2

SSCrazy

Points: 2419

April 10, 2003 at 8:31 am

Thanks,it works fine.