SELECT fagents.Agent, CONCAT(fagents.AgentLname,' , ',fagents.AgentFName) as Name from fagents
Worked! Thanks again
_agx_
> each record is displayed as 0.0 ?? what could cause that?
FWIW, it's because MySQL only uses "+" for addition. If you use it with strings, MySQL attempts to convert the strings to numbers first. Since a name like "John" or "Smith" isn't a number, MySQL converts it to zero.
SELECT 'John' + 'Smith' AS Name <== translates to SELECT '0' + '0' AS Name
The behavior's similar to CF's Val() function. Val() converts any non-numeric values to 0.
<cfquery name="agent" datasource="test">
SELECT f.Agent
,f.AgentLname + ' ' + f.AgentFName as AgentFName
from fagents
</cfquery>