>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
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com