-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|