testconnString = "Select Distinct faiindex, dcrpriorty, csource, partno, complete," +; " reqestby, Date(comitdate) As comitdate, comitby," +; " Case When csource = 'FAI' Then '<a href=''/QMSWebApp/FAIPrintServlet3.java?p1=''+faiindex+''>'" +; " When csource = 'MRR' Then 'See MRR Document' Else comitnote End As comitnote," +; " dwgrev, dwgindex, reqrejectd, requestnt" +; " From webprddt1.drawmfaie Where complete = 0 And deletedst = 0 And faiindex = 1622138" +; " Order By dcrpriorty, Date(comitdate) ASC"