how to select last two characters of a string

Question

how to select last two characters of a string

want_to_know

SSC Veteran

Points: 256
More actions
April 17, 2008 at 9:42 am

#181538

Hi
I need to select last two characters of a field like the field has codes
Ex:
abcDE
cccDE
bbbDE
and i want to get the codes that has the last two characters=DE
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

want_to_know (4/17/2008)
Hi
I need to select last two characters of a field like the field has codes
Ex:
abcDE
cccDE
bbbDE
and i want to get the codes that has the last two characters=DE
Thanks

declare @STR varchar(20)

set @STR - 'abcDE'

select right(@str,2)

That help?

😎

want_to_know SSC Veteran Points: 256 More actions · Answer 2

Yes it did

Thank you so much Lynn

Have a wonderful day

Jim Dillon-291542 Hall of Fame Points: 3344 More actions · Answer 3

Just to make sure you get good data:

RIGHT(RTRIM(LTRIM(column_name)), 2)

With the previous example, you could have gotten a space instead of the desired two characters.