Support 805.461.7300
Our Technology. Your Success.

Delete a field if the field is blank for all records

*!* Get Field Name

*!* Count records that are not empty
COUNT FOR !EMPTY(&com_FieldName) TO com_Count

*!* Create a Delete Column String if Count is 0
com_AlterString=IIF(com_Count=0,[ALTER TABLE (ALIAS()) DROP COLUMN &com_FieldName],[])

*!* Run AlterString line

« Back to Commands

Your support have been one of the best I have ever worked with.
M.L., Philadelphia, PA