Hi Kristian, Thank you very much for your help. I got it with your suggestion. I changed SQL to 'select * from tig_users where user_id like 'test_01=_%' {escape '='};' and got the results same as I want. >From this case, I know that ij work with JDBC rule. It is very useful for my next step to learn. Thanks and Regards, Li
-- View this message in context: http://apache-database.10148.n7.nabble.com/got-wrong-data-with-using-as-condition-tp144340p144342.html Sent from the Apache Derby Users mailing list archive at Nabble.com.