Answer to Question #33335 in Databases | SQL | Oracle | MS Access for teresa

Question

How would i correct a concat statement in a stored procedure that uses a cursor in MySQL so that it would display the result like this:"Gibson SG","2517.00"|"Gibson Les Paul","1199.00"|. Here is what i have for my concat statement: set answer=concat(answer, "",product_name,',',"", list_price, '|');