>CommandText: SELECT prd_prd_cd,prd_prd_nm,prd_mem_pr FROM ic_prd ORDER BY prd_prd_nm WHERE prd_mem_pr = 1
>
>
>There is no second WHERE clause in the SQL.
>

Yes, but WHERE clause is supposed to be before ORDER BY.

Thanks,
Aleksey.