Query building in MSSQL - split result in different values
Budget: €8 – €30 EUR
Hi,
My actual Query:
+++++++++++++++++++++++++++++++++++++++++++++++
SELECT *
FROM dbo.LGDOXISCODE
WHERE lgcode = '93442/52/31'
+++++++++++++++++++++++++++++++++++++++++++++++
THE RESULT IS:
R35SU.24.830.01-21 (FINE!)
+++++++++++++++++++++++++++++++++++++++++++++++
My target is to split this results as other fields by this way.
Value1= R35SU (always5 characters -text-)
value2= 24 (always 2 characters -text-)
value3= 830 (It can be also 2 characters -text-)
value4= 01 (It can be also 3 characters -text-)
Value5= 21 (always 2 characters -text-)
Who can split this Query?
FTP or Database access not allowed.
I'm looking just for the Query.
Thanks in advance.
My actual Query:
+++++++++++++++++++++++++++++++++++++++++++++++
SELECT *
FROM dbo.LGDOXISCODE
WHERE lgcode = '93442/52/31'
+++++++++++++++++++++++++++++++++++++++++++++++
THE RESULT IS:
R35SU.24.830.01-21 (FINE!)
+++++++++++++++++++++++++++++++++++++++++++++++
My target is to split this results as other fields by this way.
Value1= R35SU (always5 characters -text-)
value2= 24 (always 2 characters -text-)
value3= 830 (It can be also 2 characters -text-)
value4= 01 (It can be also 3 characters -text-)
Value5= 21 (always 2 characters -text-)
Who can split this Query?
FTP or Database access not allowed.
I'm looking just for the Query.
Thanks in advance.