Replace characters in string in a Stored Procedure
Posted on 2010-09-12
I am creating an ajax output from an stored procedure but cannot include from any text within the fields e.g. [ & or '
is there a function that I can use within the stored procedure to replace or encode the strings?
Also I have this query but would like to convert to a Stored Procedure - is this possible>
SELECT company, name1, name2, name3, name4, qty
WHERE id = 1