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.