HI, this code was originally written for asp direct to an ORacle DB, but we are changing it to ASP.net 1.1 and SQL to get information into another program to use it. The problem is I am having trouble with all the DECODE statements and transfering them over to T-SQL. I changed the qutoes from single to double in all DECODE statments and that took away the first error I received but now I am having trouble getting past this one.
[OLE/DB provider returned message: ORA-01756: quoted string not properly terminated
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
SELECT * FROM OPENQUERY(SIDPERS,
DECODE(SUBSTR(at.GRADE,1,1),"O",SUBSTR(at.POSC,1,3), SUBSTR(at.POSC,1,4)) DMOS,
DECODE(UIC_Lock.Stat,"C","</br>Crit UIC","L","</br>Locked"," ") Crit_Bonus,
from SIDPERS.PERS_AUTH_STR_TBL at INNER JOIN
SIDPERS.PERS_UNIT_TBL ut on ut.upc = at.UPC')