"rodchar" <rodchar@discussions.microsoft.com> wrote in message
news:05074FEC-2A9C-4286-9A2B-0BC986741493@microsoft.com...
> hey all,
>
> if i have a field that contains values like these:
> BOC123
> MC123
> FIN123
>
> How do i just get the letters?

"Chris Hohmann" wrote:

> "rodchar" <rodchar@discussions.microsoft.com> wrote in message
> news:05074FEC-2A9C-4286-9A2B-0BC986741493@microsoft.com...
> > hey all,
> >
> > if i have a field that contains values like these:
> > BOC123
> > MC123
> > FIN123
> >
> > How do i just get the letters?
>
> DECLARE @s VARCHAR(8000)
> SET @s='BOC123'
> SELECT LEFT(@s,PATINDEX('%[0-9]%',@s)-1)
>
>