I've hit a situation in a legacy application that has records with alpha and text fields that contain numerous non-printing characters. The non-printing characters are causing non-printing.
How do I go about finding the records the have invalid characters and deleting the Char(0)? One approach would be Query by formula checking to see if the position of Char(0)>0 but that seems to be a painfully resource intensive approach. Another tack would be to update the trigger code but that means I only get cleaned up data if the record is modified. Thoughts, comments, suggestions, etc. on this issue are welcome. -- Douglas von Roeder 949-336-2902 ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************