Hi,
I have a requirement where I need to concatenate 2 numerical columns in between '-'.
for ex: column1 value - 12345
column2 value - 67
then the result should be '12345-67'
I have used this statement in column formula
cast((column1) || '-' || ( column2) as varchar).
I am getting syntax error. Can somebody please help.
Thanks,
Seshu.