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

Try "select * from drilldown where csearch like 'BOOK%'" or
"select * from drilldown where csearch like 'BOOK???'"

% is any number of chars
? is one char


HTH
Jeff