gistfile1.sql

if exists (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'WBC_UserProfileMap' and COLUMN_NAME = 'InitIndicator')
begin
    update
        WBC_UserProfileMap
    set
        InitIndicator = 'SELF_REGISTERED'
    where
        CISKey = 'TestUser80';

    update
        WBC_UserProfileMap
    set
        InitIndicator = 'STAFF_REGISTERED'
    where
        CISKey = 'TestUser81';

    update
        WBC_UserProfileMap
    set
        InitIndicator = 'MIGRATED'
    where
        CISKey = 'TestUser80';
end
go