Select SQL statement with * as wildcard character

[NetNovice]

I am trying to populate a combo box with a subset of names from an Access data base using the * character.

The Debug.Writeline text of the SQL statement I am using in the SELECT statement is:

SELECT TBLNames.Name FROM TBLNames WHERE (((TBLNames.Name) Like "Rob*"))

This SQL statement works within the Access db itself to return all names starting with Rob.

But in .NET it only returns the name, Rob*, if I force that into the db.

Can anyone help?

[si_the_geek]

Try using % instead of * (and _ instead of ?)

[salvelinus]

You want Rob to be in single quotes, not double.

[NetNovice]

Thanks a lot, Si - the % worked straight up.

You've saved me some hours of hassle tonight!!