Concatenate columns, separated by double quotes

I need to concentate columns of data and format with double quotes between
some of the values (but not all). CONCATENATE will not recognize the double
quote character as a text value to insert into the output column.

Use CHAR(34) instead of the "


"Felicia" wrote:

> I need to concentate columns of data and format with double quotes between
> some of the values (but not all). CONCATENATE will not recognize the double
> quote character as a text value to insert into the output column.

Perfect. Thanks!

"Duke Carey" wrote:

> Use CHAR(34) instead of the "
>
>
> "Felicia" wrote:
>
> > I need to concentate columns of data and format with double quotes between
> > some of the values (but not all). CONCATENATE will not recognize the double
> > quote character as a text value to insert into the output column.