Works for most english names, but how do you handle: mao-tse-tung J. R. R. Tolken George Herbert Walker Bush World Be Free Kiefer William Frederick Dempsey George Rufus Sutherland
or, my favorite: Ralphie That is a legitimate name-- it was on his birth certificate and Driver's License :) HTH Dick There are only two things of importance. One is the customer, and the other is the product. If you take care of customers, they come back. If you take care of your product, it doesn't come back. It's just that simple. And it's just that difficult. -Stanley Marcus On Feb 6, 2005, at 8:26 AM, Brad Wilcox wrote: > Hi, > The best way I found to concatanate in MySQL is > INSERT INTO tableOne > (FullName, etc) > SELECT > CONCAT(customers.firstName, ' ', customers.lastName) AS > fullname, etc. > FROM tableTwo ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193230 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
