How to concatenate variables?

kiza — Wed, 01 Aug 2012 16:34:41 GMT

Hello, is there a way to concatenate variables like you do in Excel? Say I want to do year(column_name) &" -"& floor(field_name)? I am trying this for a new column I created and i wanted to input a similar formula

Thanks

Re: How to concatenate variables?

pmroz — Wed, 01 Aug 2012 18:23:00 GMT

The string concatenation operator is two vertical bars: ||

Note that if you want to concatenate a number you have to convert it to a character string first, using the CHAR() function. So your example would be:

char(year(column_name)) || "-" || char(floor(field_name))

If your table has columns called column_name and field_name, then a column formula would be:

char(year(:column_name)) || "-" || char(floor(:field_name))

topic Re: How to concatenate variables? in Discussions

How to concatenate variables?

Re: How to concatenate variables?