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

[Back to original message]