Using a INSTR like function in SQL (500 points)
Posted on 2003-03-11
I need to run the following query (it worked in access, but access stinks), but I can not get it to work in SQL 2000 because SQL does not support an Instr() function.
The big thing is for me to check the values within the hA.MESSAGE field and return a certain value depending on its condition. The hA.MESSAGE is very long, and I am trying to encapsulate some of the complexity from an XML dump.
I am open to creating a stored proc 1st and calling that, but I am not sure how to go about it
InStr(1,hA.MESSAGE,"database tra",1),"Db Transfer",
InStr(1,hA.MESSAGE,"restore",1),"Restore") AS Type,
hA.numFailed, FormatDateTime(hA.DATE_TIME,2) & " " & FormatDateTime(hA.DATE_TIME,4) AS ATA,
FormatDateTime(hA.startTime,2) & " " & FormatDateTime(hA.startTime,4) AS ATD,
FormatDateTime(hA.scheduledStart,2) & " " & FormatDateTime(hA.scheduledStart,4) AS ETD,