SALIM ALI (6/18/2009)
you could try this, it's a bit crude but works...declare @string varchar(50)
SET @string = 'ABCDEFGHIJ123'
select reverse ( substring ( reverse ( @string ) , 1 , 3 ) )
Heh... Old post I know but I just have to ask... why would you do two relatively expensive "reverses" when RIGHT will do the job just fine? (I mean before this thread got "silly". )
--Jeff Moden
Change is inevitable... Change for the better is not.