Probably - Which DB?
Mark > 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 > Virtualtours.com.au > mailto:[EMAIL PROTECTED] > > Phone: 1300 366 122 > Int: +61 3 9720 5733 > Fax: +61 3 9720 6377 > > --- > 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/ ----------------------------------- [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [www.safefrombees.com] --- 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/
