I have a field that looks like this: E(1),D(AB),E(12345),...
I need to pull that data into a temp table that looks like this:
DET Detcode
E 1
D AB
E 12345
I was thinking somthing like this:
select left(field,1)as detcode
into temptabel
from table;
select mid(field,3,1)
into temptable
from table
where mid(field,5,1) = ","
the problem with that is it will take a tremendous code to cover all possibilities.
any help is very appreciated
I need to pull that data into a temp table that looks like this:
DET Detcode
E 1
D AB
E 12345
I was thinking somthing like this:
select left(field,1)as detcode
into temptabel
from table;
select mid(field,3,1)
into temptable
from table
where mid(field,5,1) = ","
the problem with that is it will take a tremendous code to cover all possibilities.
any help is very appreciated