SQL statement

Hi,

I think my brain is dead today.

Select * From tblClients Where LastName LIKE 'and*'

eof is true although I know there are clients with lastnames beginning with and.

Why?

Are you using SQL Server if so i think the wild card charactor should be a %

Access 97
ADO 2.6

Try using % not * I think it will then work.

Have you tried if

Select * From tblClients Where LastName LIKE '*'

retrieves anything?

worked for me.. im using access 2k though.. wouldn't imagine it changed though

Hiya
I've just tried an old VB client ive got for a Access 97 db and
it finds a user when i use % but fails when i use *

go figure?

Thanks guys.