Anilrgowda

I need to combine two fields in a SQL query and having some trouble...

SELECT MAN.intcaseID,
STA.strCaseStatName,
ACT.strCaseActTypeName,
MST.strActivityDetail,
MST.strModifiedBy,
UPr.strfname,
UPr.strlname,
MST.dtiModified
FROM tbl_casemain MAN LEFT JOIN tbl_caseseverity SEV ON SEV.intCaseSevID = MAN.intCaseSevID
INNER JOIN tbl_casemaindata MDA ON MDA.intCaseID = MAN.intCaseID
INNER JOIN tbl_casemainstatus MST ON MST.intCaseID = MAN.intCaseID
INNER JOIN tbl_casestatus STA ON STA.intCaseStatID = MST.intCaseStatID
INNER JOIN tbl_caseactivitytype ACT ON ACT.intCaseActTypeID = MST.intCaseActTypeID
INNER JOIN tbl_casemaindetails MDT ON MDT.intCaseID = MAN.intCaseID
LEFT JOIN tblUser_profile UPr
ON UPr.strcuid = MST.strModifiedBy
WHERE MAN.intcaseID = 19
ORDER BY MST.dtiModified

I have tried using [UPr.strfname] & " " & [UPr.strlname] AS FullName, but it didnt work. Is there a concatenate entry in SQL that I should be using? So when I enter #FullName# in my code on the web page it displays "John Smith" in my cfgrid instead of having two columns.

------------------

Anilrgowda

SQL uses + and not & to concatenate strings, and single quotes and not double quotes surrounding them.

[UPr.strfname] + ' ' + [UPr.strlname] AS FullName

------------------