Concatenation of Integer with Character

[s***@lmkr.com]

Hi,

How can we concatenate Integer with Character?
COALESCE function doesn't allow to do this.

Thanks,

[Knut Stolze]

Post by s***@lmkr.com
Hi,
How can we concatenate Integer with Character?
COALESCE function doesn't allow to do this.

Use the CHAR function to convert the integer to a string, then concatenate
or use COALESCE (depending on what you want to do).

[s***@lmkr.com]

Thank you very much Knut