you could do it in the SQL:
SELECT
left(employee_fname, 1) + employee_lname AS empName
FROM
employees
you would do it pretty much the same way in CF.
<cfset empFullName = left(getName.employee_fname, 1) &
getName.employee_lname) />
On 12/6/05, Orlini, Robert <[EMAIL PROTECTED]> wrote:
> How do I trim the letters of an employee's first name (employee_fname) to the
> first letter and then add it to the letters of their last name
> (employee_lname)?
>
> For example, "John Smith" edited and then copied to a username field as
> "JSMITH". I'm assuming its a RTRIM.
>
> Here is the code I have to work with:
>
> <cfquery name="getname" datasource="name">
> select employee_fname, employee_lname
> from employees
>
> Thanks.
>
> Robert at HWW
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 12/5/2005
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226296
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
