>I am haveing trouble with this SPT. It excludes any records that have a value in the recseq field that does not match my recseq criteria.
>
>

>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"
>
>

>
>First the webprddt6.drawmextc3 table contains no records with a recseq = 52632. However it does contain 4 records with recseq = 69607.
>
>Secnd my desired result is this should return 70 records which is the count of webprddt6.drawmextc1. It however only returs 66 records, excluding the 4 records already existing in the table. How do change the Where filter to include records that might have a different recseq?

Which records do you want to get? It looks to me that you want to get all records regardless on RecSeq number, so you don't need WHERE condition at all.