I have a table TableA with the following field value for column 'Property'
Then I need the output as
EmployeeID ASC, AddressID DESC (eliminating the pipes in the same order as they appear)
If there were sorts on other columns, then it would be appended following a semicolon.
We cannot predetermine on how many columns the sorting is done..
So the value of 'Property' could be:
[EmployeeID]|ASC;[AddressID]|DESC;[Name]|ASC;[Title]|DESC (and so on)
The above field value for 'Property' in this case needs to be parsed to get the following value:
ORDER BY EmployeeID ASC, AddressID DESC, Name ASC, Title DESC