Try the Replace function replace the `-` character with `` -----Original Message----- From: Luc Foisy [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:09 AM To: MYSQL-List (E-mail) Subject: String Functions
Is there any function to strip non numeric characters from a string? Such that FUNCTION('1-(519)-473-3853') would return '15194733853' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]