First thought: #Left(employee_fname,1)##employee_lname#
Orlini, Robert 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 > -- ================================================================= Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org ================================================================= ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226289 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
