blueknight529
IS-IT--Management
Table contains a field as below:
record_id
FL|8|B-94|12|3
FL|8|E336|12|9
GA|59|SL12BTJ507|12|1
Due to program limitations, I MUST use ONLY MS Jet SQL.
I need to SPLIT this field into 5 Variables, using the "|" as a delimiter.
No VBA, No Function Building, No Access Features, strictly using MS Jet SQL.
Desired Result
Var1=FL, Var2=8, Var3=B-94, Var4=12, Var5=3
Var1=FL, Var2=8, Var3=E336, Var4=12, Var5=9
Var1=GA, Var2=59, Var3=SL12BTJ507, Var4=12, Var5=1
record_id
FL|8|B-94|12|3
FL|8|E336|12|9
GA|59|SL12BTJ507|12|1
Due to program limitations, I MUST use ONLY MS Jet SQL.
I need to SPLIT this field into 5 Variables, using the "|" as a delimiter.
No VBA, No Function Building, No Access Features, strictly using MS Jet SQL.
Desired Result
Var1=FL, Var2=8, Var3=B-94, Var4=12, Var5=3
Var1=FL, Var2=8, Var3=E336, Var4=12, Var5=9
Var1=GA, Var2=59, Var3=SL12BTJ507, Var4=12, Var5=1