>>>The function is QUOTENAME
>>>
>>>select QUOTENAME ( HomePhone , '"' ) from people
>>
>>This is what I was just looking for.
>>
>>How can I specify single quote here to be a parameter ?
>
>
>select QUOTENAME ( HomePhone , '''' ) from people
>
Thanks :) At the end I didn't use it.
If it's not broken, fix it until it is.
My Blog