'like' problem with asp.net/ ado
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.