strip numeric portion of a string

[pelusa]

Hello,

I would like to know how to get only the last 7 characters of a string of 22 varchar

my string can be:

3027777777450A80000001

or

A027777777450550000001

but the last 7 characters will always be numbers.


Thank you for your help.

[Jim Doherty]

Hello,

I would like to know how to get only the last 7 characters of a string of 22 varchar

my string can be:

3027777777450A80000001

or

A027777777450550000001

but the last 7 characters will always be numbers.


Thank you for your help.

SELECT right([yourfieldname],7) AS Mychars FROM yourtablename

will give you the extreme rightmost seven characters aliased to a column name of mychars

Jim :)

[pelusa]

Thanks Jim! that worked so far :-)