Posted by KR on 02/06/06 23:53

KR
Feb 6, 1:48 pm show options

Newsgroups: microsoft.public.access.forms
From: "KR" <kra...@bastyr.edu> - Find messages by this author
Date: 6 Feb 2006 13:48:00 -0800
Subject: Extract Number from Fields - SQL
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

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

[Back to original message]