Cannot concatenate text in Advanced Query

I have a Select statement with:

Select {User}.Name + {User}.Username FROM  {User}

but it doesn't work. Is there something wrong?

Solution

If your stack is orace, try:

Select {User}.Name || {User}.Username FROM  {User}

Solution

Hello, 

What is the error ? What is the type of output you have ?

That was it, thank you.

If you are using an advanced query, you just need something like this:

Hi,


João Pedro's example shows you exactly how you can perform a concat in SQL. That's it, or use a concat({User}.[Name],{User}.[UserName])


Best, 

João Delgado