RE: SQL Help

[derek bumpas]

Sorry.. missed the Function for SQL Server..   My bad..       -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ricardo Sanoja Sent: Friday, September 06, 2002 3:43 PM To: [EMAIL PROTECTED] Subject: SQL Help   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