yogi123 (4/30/2014)

---

Hello everyone

I need help to develop logic. In my query i have Alpha Numeric string with commas and hyphens.so from the string i need to populate min and max number

see below for DDL

create table #temp

(Code varchar(50))

insert into #temp values ('1,11-12ABCDEF(Y)')

insert into #temp values ('1,11ABCDEF(Y)')

insert into #temp values ('1,3-4AB1-3CD1-2,4EF(Y)')

insert into #temp values ('1,3-4MTWRF(Y)')

insert into #temp values ('1,3ABCDEF(Y)')

insert into #temp values ('1,3MTWRF(Y)')

below is the desired output

codeminmax

1,11-12ABCDEF(Y)112

1,11ABCDEF(Y)111

1,3-4AB1-3CD1-2,4EF(Y)14

1,3-4MTWRF(Y)14

1,3ABCDEF(Y)13

1,3MTWRF(Y)13

please help me to develop this logic.

Thanks