Access query problem in Delphi 2.0

Hi,

I've the following interesting Acces query problem:

In Access I've created the following query, which does work:
  SELECT *  FROM SALES AS S
  WHERE (((S.SALE_CODE) Like 'L*'))

Now I want to execute the same query using delphi 2.0. I've set up the BDE
to connect to the same Access database. I try to execute the query
using the following code:

  with Query1 do begin
    Close;
    Sql.Clear;
    sql.Add('SELECT * FROM SALES AS S');
    sql.Add('WHERE (((S.SALE_CODE) LIKE ''L*''))');
    Open;
  end;

Trying to execute this code results in the following error :

Project1        fffd0f4b:fffa57a3       EXIT  SQLError  with return code 0
(SQL_SUCCESS)
                HENV                0x00000000
                HDBC                0x00000000
                HSTMT               0x01d2050c
                UCHAR *             0x0069f7b0 (NYI)
                SDWORD *            0x0069f550 (-3100)
                UCHAR *             0x0069f5ac [     148] "[Microsoft][ODBC Microsoft
Access 7.0 Driver] Expression cannot be used with the LIKE predicate. in
query expression '(S.`SALE_CODE`) alike ('L*')'."
                SWORD                      511
                SWORD *             0x0069f54e (148)

What am I doing wrong? I've no idea. Please help!!!!!!!!!!!!!!!!

Thanks in advance,

Ronny