Concatanate in DB

[fborgmann]

Hello everybody,

I am trying to concatanate two existing fields in one field using the in DB formula tool. 

While trying, I recieve the following error message. Is there another way to do it or can you see a mistake in my syntax? 

Thanks for advice!

[Felipe_Ribeir0 · Accepted solution]

Hi @fborgmann ,

When you are using IN DB components, you must use the formulas that your DB allow you to use. For example, when you are concatenating columns in SQL Server, you must do CONCAT('wil_code', 'dtc_code'). And you must be sure that the columns that you are concatenating  are strings to do that, because this function is for strings.

https://www.w3schools.com/sql/func_sqlserver_concat.asp 

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.