How does the LIKE predicate operator treat trailing spaces
in a CHAR column. For example,
create table test(c1 char(5));
insert into test('abc');
select c1 from test where c1 like 'abc%';
should retrieve one row.
select c1 from test where c1 like 'abc';
should retrieve zero rows.
select c1 from test where c1 like 'abc ';
should retrieve one row.
Correct? Does this conform exactly to the SQL 92 spec?