Insert double quotes into SQL output

Question

After I run a query and view the output, for example

select * from People

My output is as follows

First   Last      Email
Ray     Smith     [email protected]

How would I export this data so that it looks as follows?

"Ray","Smith","[email protected]"

Or is there a way to do this within SQL to modify records to contain quotes?

Because when you export, it's going to include the commas anyway, right?

Answer 1

If the columns you're interested in are 128 characters or less, you could use the QUOTENAME function. Be careful with this as anything over 128 characters will return NULL.

SELECT QUOTENAME(First, '"'), QUOTENAME(Last, '"'), QUOTENAME(Email, '"')
    FROM People

Answer 2

select '"'+first+'","'+last+'","'+email+'"'
from people

This is the kind of thing best done in code however, you shouldn't query for presentation.