Query building in MSSQL - split result in different values

Job ID: 35923607

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.
Related categories: SQL Microsoft SQL Server