>I need to get a set of records from an as400 data base using SPT. I would like to use two fields in my Where clause but I can't seem to get it to work.
>
>My SQL statement is:
>jn = "'MES4000CHI'"
>"Select * From webprddt6.drawmstrp Where dm_job_order + dm_customer = " + jn
>
>Or would it be better to get the records matching the dm_job_order, which works, and do do further filtering on the cursor?
Split job_order and customer
m.jo = "MES4000"
m.cs = "CHI"
[Select * From webprddt6.drawmstrp Where dm_job_order ='] + m.jo + ;
[' AND dm_customer = '] + m.cs + [']
--sb--