i have a dataset,
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:
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.