How can I put my field values inside quotes (SQL) -

code below puts quotes around value in field contains comma.

select case when charindex(',',myfield) > 0  '"'+ myfield +'"' else myfield end myfield  mytable

the issue want select myfield address since have end dont know how go about. hope question clear. please.

unless i've misunderstood you, can add myfield address query:

select    case when charindex(',',myfield) > 0    '"'+ myfield +'"' else myfield end myfield,   myfield address  mytable

update

to 1 column named address:

select    case when charindex(',',myfield) > 0    '"'+ myfield +'"' else myfield end address mytable

And