Concatanate in DB
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- In Database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
