table a col1 col2
A B
A1 B1
B BB
1A1 BBBselect * from a where col1 like '%A%';it will return
col1 col2
A B
A1 B1
1A1 BBB
A B
A1 B1
B BB
1A1 BBBselect * from a where col1 like '%A%';it will return
col1 col2
A B
A1 B1
1A1 BBB
select name from table where name like 'a_';
select name from table where name like '%a%';
select name from table where name like '_a_';
select name from table where name like '%a';
select name from table where name like '_a';
you can not use '+'you should use '||'var||'a'