RE: SQL Help

[derek bumpas]

I’m assuming you know how to write a function..   <!--- SNIP -à   <CFSET TEST=REREPLACE("1234-123-1233-1233", "[^0-9]*",'',"ALL")>   <CFOUTPUT>#TEST#</CFOUTPUT>   <!--- SNIP -à     Hope this helps!   Derek     -----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