BAH! I was passing the where clause as a custom
Tag attribute and which was causing the single
Quotes to be escaped...

WHERE  Len(Replace(mobileNumber,' ','')) = 10
Became
WHERE  Len(Replace(mobileNumber,'' '','''')) = 10

Thank you PreserveSingleQuotes() !!

(and to those who offered suggestions..)

Cheers,
Adam

---
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/

Reply via email to