how can i concatenate fields inside of my dataset?

Question

i have a dataset, `dataset1`: i am trying to do: ``` select col1+col2, col3 from mytable ``` this does not work; however this is no problem: ``` select col1, col2, col3 from mytable ``` how can i concatenate fields inside of my dataset? please note that `col1, col2, col3` are all VARCHARS. i've tried the `&` operator as well. please see the image below. i get the `DEFINE QUERY PARAMETERS` dialogue when it doesnt like my query:

Accepted Answer

Double quotes are not appropriate string delimiters in MS SQL. Try:

```
SELECT ppl.FirstName + ' ' + ppl.LastName AS ReferredBy
```

Putting your actual query in the question may help you get a faster response next time, since the concatenation is actually a red herring here.

how can i concatenate fields inside of my dataset?

Solution

Problem

Related problems