What programming language are you using? You could write a method to compare each character and return only those 0-9 as the output and discard the rest.
-----Original Message----- From: Luc Foisy [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:26 AM To: Victor Pendleton; MYSQL-List (E-mail) Subject: RE: String Functions That I can do REPLACE(REPLACE(REPLACE(REPLACE(str,'(',''),')',''),'-',''),' ','') Looks kinda horrid to handle removing just four characters ( ) - and space And if any other characters end up in str, then they are not handled, and my "formula" is broken. So there is no functions that would do what I need? Anyone have some kind of "formula" (multiple functions perhaps) that would simulate what I need, something that would only return numeric characters? -----Original Message----- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:15 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: RE: String Functions 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]