Hello All, I will get a string of error codes from my vendor in a comma seperated format. I need an xquery function, which will return "Success" or "Failure" or "Error" based on the following:
If string contains AE* or -> Return "Failure" else if GE* or SE* -> Return "Error" else "Success" Below are the samples of strings that I can receive. AS01,GS03 -> Should return Success AS01,GS01 -> Should return Success AS01,GE02 -> Should return Error AE01,GE02 -> Should return Failure Thank you very much for your help.
_______________________________________________ [email protected] http://x-query.com/mailman/listinfo/talk
