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
**********************************************************