How to append value of column with double quotes (add quotes around string) I have a table with a column that is TEXT type. In the column are numeric characters. What I'm trying to achieve is to wrap those characters in double quotes. 

EXAMPLE:

NAME     ID     QTY
Apples   A1     1
Oranges  O1     1
Foo      F1     0


IDEAL OUTPUT:

NAME     ID     QTY
Apples   A1     "1"
Oranges  O1     "1"
Foo      F1     "0"


I attempted to run the following SELECT statement but it didn't give me the result I was expecting. Perhaps you can guide me in the right direction?

SELECT `qty`, CHAR('"'|| qty ||'"')
FROM `myTable`;


Thank You
Use the CONCAT function

SELECT NAME,ID,CONCAT('"',QTY,'"') QTY FROM `myTable`;


If you want single quotes, use the QUOTE function

SELECT NAME,ID,QUOTE(QTY) QTY FROM `myTable`;


Give it a Try !!!