You could do it in the SQL:
SELECT Firstname + ' ' + lastname AS Fullname
FROM table
Then just use Fullname in you cfgrid
~JustinMacCarthy
Coming soon WWW.CFFAQ.ORG
----- Original Message -----
From: Dharmendar Kumar <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 17, 2000 11:22 AM
Subject: Newbie qts -
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_003E_01BFC017.F515F160
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I am selecting two fields in a query - firstname and lastname.
>
> I want to concatenate the two fields and display the fullname in a =
> single column in a CFGRID. How do I do this.
>
> Can anyone help me?
>
> Dharmendar Kumar
>
> ------=_NextPart_000_003E_01BFC017.F515F160
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Dwindows-1252" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>I am selecting two fields in a query - =
> firstname=20
> and lastname.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>I want to concatenate the two fields =
> and display=20
> the fullname in a single column in a CFGRID. How do I do =
> this.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Can anyone help me?</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Dharmendar =
> Kumar</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_003E_01BFC017.F515F160--
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.