SQL Help

[Ricardo Sanoja]

I am looking for a function for SQL Server 2000 that will strip out all but numbers from the left side of the equation.   Example   Select cust_id,phone From customers Where stripchar(phone) = ‘#phone_just_numbers#’   Before anyone asks, I know that stripchar is not a real function, what I need is a function that performs the task of just looking at the numbers.   Sincerely, Ricardo M. Sanoja     Senior Web Architect 4288 Kellway Circle Addison, TX. 75001 972.267.1558 Ext. 219 mailto:[EMAIL PROTECTED]   --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.384 / Virus Database: 216 - Release Date: 8/21/2002