>testconnString = "Select recseq, descptncd," +; > " CASE WHEN status Is NULL THEN 0 Else status END As status," +; > " CASE WHEN cmnt Is NULL THEN '' Else cmnt END As cmnt, clcode From webprddt6.drawmextc1" +; > " Left Join webprddt6.drawmextc3 On webprddt6.drawmextc3.codeid = webprddt6.drawmextc1.clcode" +; > " Where (recseq = 52632 Or recseq is NULL) Order By clcode" > >>
TEXT TO testconnString NOSHOW Select recseq, descptncd, ISNULL(Status, 0) AS Status, ISNULL(cmnt, '') AS cmnt, clcode From webprddt6.drawmextc1 Left Join webprddt6.drawmextc3 On webprddt6.drawmextc3.codeid = webprddt6.drawmextc1.clcode Where ISNULL(recseq,52632) = 52632 Order By clcode ENDTEXTThat should (and that is your SELECT) give you ALL records where RecSeq is NULL or RecSeq = 52632.