Q:

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

Code below puts quotes around any value in the field that contains a comma.
SELECT case when CHARINDEX(',',myField) > 0 
THEN '"'+ myField +'"' else myField END AS myField 
FROM myTable

The issue is that I want to select myField as Address but since I already have END AS I dont know how to go about. Hope my question is clear. Any help please.

A:

Unless I've completely misunderstood you, you can just add myField as address to your query:
SELECT 
  case when CHARINDEX(',',myField) > 0 
  THEN '"'+ myField +'"' else myField END AS myField,
  myField as address 
FROM myTable

UPDATE
To get only one column named address: 
SELECT 
  case when CHARINDEX(',',myField) > 0 
  THEN '"'+ myField +'"' else myField END AS address
FROM myTable

