how to remove single quotes from procedure variable

dimpal bhendarkar

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'"

i just wann remove single quote from @ddl_one so that it treat as column name

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Khargesh Rajput11y ago
begin
exec ('SELECT * FROM topic WHERE '+@name+' LIKE ''%'+ @param_one + '%''')
end
dimpal bhendarkar11y ago
sorry to say... but it doesn't work
Rahul Bansal11y ago
Try REPLACE(@ddl_one,'''','')

like

ALTER PROCEDURE LibAdvancedSearch
@ddl_one varchar(50)=null,
@param_one varchar(50)=null
AS
begin
SELECT * FROM AddBookDetailsLib
WHERE REPLACE(@ddl_one,'''','') LIKE '%' + @param_one + '%'
end
RETURN