• I don’t have SQL Server CE edition, so I can’t check it, but why do you think that you need to use begin end block? Can’t you just use this code?

    IF NOT EXISTS (SELECT *

    FROM INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = 'DELIVERYINTRIP'

    AND COLUMN_NAME = 'PODID')

    ALTER TABLE DELIVERYINTRIP ADD PODID UNIQUEIDENTIFIER NULL

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/