>>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.