|
|
Posted by Hugo Kornelis on 02/07/06 00:53
On 6 Feb 2006 13:53:35 -0800, KR wrote:
> 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.
Hi KR,
The function you would use to find where a three digit sequence in
varchar data is located is
POSINDEX ('%[0-9][0-9][0-9]%', CharData)
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|