问题描述:

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:

网友答案:

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.

相关阅读:
Top