Boyd, Mark Thomas (US - Philadelphia)
mboyd at deloitte.com
Tue Nov 29 12:02:13 CST 2005
I'm sure this is possible, but have never coded it. I have 50 tables, each containing 50 fields. Some of the fields contain empty strings. I need to cycle thru every table, and update all empty strings to null. Is there a way to cycle thru each table, and cycle thru each field record by record, and update to null where necessary? I want to avoid using specific table and field names. Any ideas? Thanks. Mark Boyd Senior Consultant Enterprise Risk Services Deloitte & Touche LLP Tel: +1 215 405 5576 mboyd at deloitte.com www.deloitte.com <http://www.deloitte.com/> This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]