Hi

Like operator in SQL queries with parameter do not work !

Sample:

create table test(Name char(4));

insert into test (name) values ('2011');
insert into test (name) values ('2012');
insert into test (name) values ('2013');
insert into test (name) values ('2014');
insert into test (name) values ('2015');
insert into test (name) values ('2016');
insert into test (name) values ('2017');
insert into test (name) values ('2018');
insert into test (name) values ('2019');


select * from test where name like :NAME;

If you execute this in ARC and enter any value, the first select works, changing the paramter value will not return any result.

We upgraded a couple of customers between Christmas and New Year and have to switch back to Ver.11!!

This needs to fixed urgently!

Marcus