How to Concatenate Include Comma(,)?

Analytics
Highlighted
Enthusiast

How to Concatenate Include Comma(,)?

Hi,
Those who can share the knowledge,

If I need to concatenate 2 column, let say City and Country,
City--------Country
NY--------USA
TKYO--------JPN

By using SQL function:
SEL Concat(City,Country)
From Demografic

The Result showing:
NYUSA
TKYOJPN

My question:
How to come out the result with comma(,) like this:
NY,USA
TKYO,JPN

Many thanks in advance.

2 REPLIES
Enthusiast

Re: How to Concatenate Include Comma(,)?



SEL City || ',' || Country
From Demografic;
Enthusiast

Re: How to Concatenate Include Comma(,)?

Thanks! ^_^