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/
