Then stop talking to us and make that call! :OP What are you doing reading this?! Phone!!
:OD -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 23 February 2005 23:55 To: CF-Talk Subject: RE: OT-SQL matching Essentially yes, I just wasn't sure what exactly his criteria for matching was -- if he (you?) needed an exact match including the suffix or if he needed to match only the last name... You'll have to forgive me for not knowing who made the original post, I'm a bit distracted -- tired from walking home since my car is at the mechanic and in a hurry to call a potential client. > That's a great idea, do the join on a calculated field! > ON OnlyLastName + ' ' + Suffix = LastNameAndSufix > Is that what you're suggesting? If so and it works, I like > :O) > Ade -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/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:196241 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
