>> Which DB? Ah yes.. Small detail?! MSSQL 2000
> Adam Chapman <[EMAIL PROTECTED]> wrote: > > Hey cfers (and sqlers).. > > Can this be done in SQL?? Ive looked thru > Some docs and tried a few things.. But.. > > SELECT name, address > FROM thisTable > WHERE Len(Replace(mobileNumber,' ','')) = 10 > > Basically I want to strip spaces from mobile > Numbers and make sure there are 10 digits.. > I don't really want to loop thru each number > And test its length in CF.. > > Now sql like a pig... ;P > > Regards, > > Adam Chapman --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
