Help with select statement

[edwardturner]

Hi,

I need to write a select statement to just return one field from a table but i want to also return a column either site that just contains a ' character. I know how to say add a column before / after a column:

select field, ',' from table

But i do not know how I would get the single quote character either side.

Any ideas?

 

[JamesLean]

You just need to double up the single quote:

SELECT field, '''' FROM table

--James

 

[micha123]

I'm not sure I understood what you need, is this is:

select ','+field+','

?

"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M.

 

[SimonSellick]

You could use either of these, depending on what you want to end up with:

select '''' QL, 'a' COL, '''' QR
returns 3 cols:
QL COL QR
' a '

select '''' + 'a' + '''' QL_COL_QR
returns one col:
QL_COL_QR
'a'

 

[edwardturner]

doing SELECT field, '''' FROM table worked!

Thanks.