Extract Number from Fields - SQL

K

KR

I am new to the SQL world, and I am trying to come up with a script
that will extract only the numerical data from a column of varchar
data type . There is not a pattern to the data entered, except that
the data that
I am looking to extract is a three digit number. If someone could
point me in the right direction that would be great.


Thanks in advance
KR
 
A

Al Camp

KR,
Please give several examples of what the field might contain.
Are there any other numbers in the string except for the 3 consecutive
ones?
 
J

John Vinson

I am new to the SQL world, and I am trying to come up with a script
that will extract only the numerical data from a column of varchar
data type . There is not a pattern to the data entered, except that
the data that
I am looking to extract is a three digit number. If someone could
point me in the right direction that would be great.


Thanks in advance
KR
Click to expand...

Are you doing this in SQL/Server, using T-SQL? Or in Microsoft Access,
using Access syntax?

John W. Vinson[MVP]
 
Top