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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Extract Text from decimal separated string 6
How to recover SQL server database from corrupt mdf file? 3
Extract a number from a table using coordinates 2
What are the steps to fix damaged MDF files in SQL Server? 0
how to extract a specific alpha numeric pattern from a string 4
Extracting Data 1
How to subtract a number from a Mergefield? 0
Access stripping decimal places in query 1

Back
Top