Unanswered: Need advise with stored proc + ASP issue.
Wrote a simple stored proc to list out names which have one param to see whether is it a full listing or whether is it based on alphabetical
CREATE PROCEDURE usr_listcontractors(@sortby varchar(2))
If @sortby ='fl'
select * from contractor where deleted ='N' order by 'CName'
select * from contractor where cname like @sortby+"%" and deleted ='n' order by 'CName'
The above works fine in query analyser (exec usr_listcontractors)