At 12:28 PM 02-09-02 +0200, you wrote:

> Statement stmt = conn.createStatement();
> String sql = "SELECT * FROM ma_journal where ma_mdato >= '2002-07-29' AND
>ma_slo NOT LIKE 'P' order by ma_slnr desc"

Well, try correct syntax for the LIKE predicate:

ma_slo NOT LIKE '%P'

Helen