I've done something similar with part numbers. The hard part isn't doing lookups -- one table, three columns (id, name1, name2), two subselects -- the hard part is populating that table.
I'm happy to show you how to do the lookup, but do you have a plan for populating the table? --Ben Doom Jake Pilgrim wrote: > Has anyone implemented "smart names" (i.e. a search for "Bob" would match > "Bobby" or "Robert") functionality in Coldfusion? Anyone have any examples I > can view? > > Thanks! > Jake Pilgrim > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4