Hi

I would like to make a SQL Statement like:

Select * from TABLE1 where Field1="The first 8 charaters from another
field"

I.e.

Select * from Table1 where Field1=Left(Field2,8);
(Taken from access)

Regards

Michael