PROBLEM WITH LIKE OPERATOR IN SELECT WHERE CLAUSE

Hi,
1. In difference from = operator, LIKE opearator does not ignore trailing blanks in CHAR type fields. 2. This means that for a CHAR(5) field containing ABC , the following SELECT statement will return no lines : SELECT * FROM table WHERE field LIKE A%C , whereas following SELECT statement will return the line :
SELECT * FROM table WHERE field = ABC . 3. Does anyone have a bypass to this problem that doesn t require to pad blanks to the searched string and that doesn t inluence performance ?
thanks very much
shamai  

--