how to parse a string in mssql

[manu19855]

here i have a string
'Employee_Test. EmployeeID^^=^^ 3 and Employee_Test.N ationalIDNumber ^^<=^^555-555-555'

here employee.test is table name
followed my column name ie employeeid
and logical operator may be =,<=,>= etc

^^ represents delimiter


i want to parse the string as

Employee_Test.E mployeeID='3 'and Employee_Test.N ationalIDNumber <='555-555-555'

can u plz help me out

[dorinbogdan]

Is there any pattern used to build that string?
Or, can it contain any field names in any order?