Hi,
I am tryng to select some data from a table in SQL, the command is:
"select * from drilldown where csearch like 'BOOKS' order by nindex"
This works fine.
When I introduce the wild card as in:
"select * from drilldown where csearch like 'BOOK*'"
This fails to get any data, both work in the SQL query window, but the second fails when I deploy it on the ASP.
Any ideas why?
Kind regards,
Kev
**********************************************************
www.brainbashers.com**********************************************************