Click to See Complete Forum and Search --> : Iliminating Characters from set of integers and characters


Chaze
07-19-2006, 02:34 AM
Good day experts,

I wonder if i got an answer for this.
How can i iliminate a letters from a set of integers and characters using a SQL Statement

for ex:

ABC9800468F

is that possible?
is there a function that i can use to iliminate them?

Marin
07-30-2006, 08:37 PM
Use Replace function to replace all numbers with empty string (yes, you would need 10 of them, but that is the easiest solution).

Cheers, Marin