Hey gang, I have three possible inputs: 18005551212 +18005551212 8005551212 Right now I am using this to strip off the +, 1, or +1: INSERT INTO ... VALUES(SUBSTRING(usernumber FROM '^\\+?1?(.*)')); This works perfect but I get all of these in the log: WARNING: nonstandard use of \\ in a string literal at character 181 If I change to this as per the doc example right above the 9.7.3 header on this page: http://www.postgresql.org/docs/8.2/static/functions-matching.html SUBSTRING(usernumber FROM '^#+?1?(.*)' FOR '#') I get NULL inserted but no WARNING's. A point if the right direction would be appreciated. Thanks, Matthew ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
