I have a simple asp.net webpage that uses a bound datagrid
via a .net ado connection.

I have a problem with a query that runs when I use under my Access
2002 query builder pane but does not run when I use it via my
ado connection. the query syntax is as follows:

'select * from employees where firstname like '*ste*'

under the Access query pane I get all employees whose first name
contains 'ste' ( eg stephen, steve, steven, etc)

However when I run this query under ado - I get no records returned.
Should I use different wildcards ( ie '*' characters ) under ado ?

Any suggestions much appreciated.
Cheers
Chas.

Use % instead (http://www.adopenstatic.com/faq/likequeries.asp)

Chas,
I think your syntax problem is the use of single quotes (').
You can't have 3 single quotes in your query, you should use
combination of double and single quotes in pairs. More than
1 pair should be excaped.
John