I have an exchange that includes the Site. Some of the supplied values may not align, and I want to translate them, but leave good ones alone. For example:
DNV -> DEV But ... KWA should remain KWA. I've tried SQL (Case statements), and IF/THEN functions. Have not found a good method to replace a select set of values, yet leave everything else alone. Any ideas out there? We're an On Demand customer, on 7.6.04. -- Thank You, Chris Danaceau FINRA Confidentiality Notice: This email, including attachments, may include non-public, proprietary, confidential or legally privileged information. If you are not an intended recipient or an authorized agent of an intended recipient, you are hereby notified that any dissemination, distribution or copying of the information contained in or transmitted with this e-mail is unauthorized and strictly prohibited. If you have received this email in error, please notify the sender by replying to this message and permanently delete this e-mail, its attachments, and any copies of it immediately. You should not retain, copy or use this e-mail or any attachment for any purpose, nor disclose all or any part of the contents to any other person. Thank you _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"