Yup, had this one bite me in the bum. Quite interesting to track down when you don't know about this behavior.
Regards Rodney > -----Original Message----- > One thing to remember with functions is that Fox will set the width > of the fields based on the first record it finds, not the widest > entry. So if your first record was "The Dam", the stripped version > will only have 6 characters, and the Fox will make the column C(6). > If your next entry is "Hoover Dam", only "Hoover" will be in the result. > ============================================================================== CONFIDENTIALITY NOTICE: The information in this electronic message (including any attachments) is confidential and may be privileged or proprietary. If you are not the intended recipient, any dissemination, disclosure, copying, downloading, or other use of the information is prohibited and unauthorized, and may be unlawful, regardless of address or routing. If you are not the intended recipient, please inform the sender immediately and permanently delete and destroy the original and any copies of this message, including any attachments. ============================================================================== _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
