ALTER PROCEDURE LibAdvancedSearch @ddl_one varchar(50)=null, @param_one varchar(50)=null AS begin SELECT * FROM AddBookDetailsLib WHERE @ddl_one LIKE '%' + @param_one + '%' end RETURN
///////////
ex: query must be like "select * from AddBookDetailsLib where BookCategoty like 'history'"
so ddl_one should get BookCategory when i set from my business access layer.. but it get with single quote like 'BookCategory', so query will be like "select * from AddBookDetailsLib where 'BookCategoty' like 'history'"