ODBC programming-- passing parameter with wildcard charecter

Hi,

I had a problem passing parameters using wildcard(ODBC progrramming)

eg:
select * from company_master where name like ?
I pass the parameter as 'L%' to get all the companies details starting with the name 'L'.

It worked fine using MS ACCESS 2000 but doesn't work in MS SQL Server 2000.


thanks in advance