It's exactly like you got it.. Did you try to run it? It should work. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adam Chapman Sent: Monday, 7 July 2003 5:47 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Replace in SQL rather that CF
>> 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/ --- 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/
