Toad World® Forums

Data Browser

In Data Browser, I would like to concatenate fields separated by ‘_’.

  1. Is this possible? If so, how?

  2. I would like to concatenate more than 2 columns. When I try this, I get an error. Is this possible?

Can you post a screenshot of the data and formula/rule you are using?

Here is the sample data set:

tble.png

Here is the error:

concat1.png

It seems that CONCAT only concatenates two columns.

You can use the following expression

Concat( Concat( [field_1], [field_2]), [field_3])

Thanks Aleksey. I would have never thought of using nested Concat.

Is there a way to contact with ‘_’ in between two fields?

Try the following

Concat( Concat( [field_1], ‘_’ ), [field_3])

I tried Concat( Concat( [field_1], ‘_’ ), [field_3]) and got the “Expression error…”.

It does not line the use of single quote along with Concat.

It works for me

Thanks… I realized that I had typo in my syntax.