SQL statement

[vbgladiator]

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?

[tom_hotspur]

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

[vbgladiator]

Access 97
ADO 2.6

[GlenW]

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

[Mc Brain]

Have you tried if

Select * From tblClients Where LastName LIKE '*'

retrieves anything?

[kleinma]

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

[tom_hotspur]

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?

[vbgladiator]

Thanks guys.