hI GilaMonster,

Below is my requirement.

declare @t nvarchar(16)

set @t = 'T5e3st003'

from this, i want to extract only '003'. For example in a variable say may be lot of integer value be there. from this i have to extract the last integer value.

declare @t nvarchar(16),@w nvarchar(16)

set @t = 'T5e3st003' (Note: in this 5 and 3 are other integer values. in result set it should not be display.)

set @w = 'Test001'

result

-----

@t = 003

@w = 001