IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'fieldName'
      AND Object_ID = Object_ID(N'pal_Attachment'))
BEGIN
    ALTER TABLE pal_Attachment
	ADD fieldName VARCHAR(500); 
END


IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'fieldName'
      AND Object_ID = Object_ID(N'pal_Note'))
BEGIN
    ALTER TABLE pal_Note
	ADD fieldName VARCHAR(500); 
END
