All Forums Analytics
Benjamin Marcus 48 posts Joined 03/07
03 Jul 2007
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--------CountryNY--------USATKYO-------- JPNBy using SQL function:SEL Concat(City,Country)From DemograficThe Result showing:NYUSATKYOJPNMy question:How to come out the result with comma(,) like this:NY,USATKYO,JPNMany thanks in advance.

Regards Benjamin Marcus
joedsilva 505 posts Joined 07/05
03 Jul 2007

SEL City || ',' || CountryFrom Demografic;

Benjamin Marcus 48 posts Joined 03/07
03 Jul 2007

Thanks! ^_^

Regards
Benjamin Marcus

You must sign in to leave a comment.