Extract Number from Fields - SQL

  • Thread starter Thread starter KR
  • Start date Start date
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
 
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?
 
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]
 
Back
Top