-- SELECT TOP 100 t.* FROM cf_FormElementPropertyValue t WHERE t.propertyId = 8 AND value LIKE '%[^a-z0-9_]%';

UPDATE cf_FormElementPropertyValue
SET value = REPLACE(
    REPLACE(
        REPLACE(
            REPLACE(
                REPLACE(
                    REPLACE(
                        REPLACE(
                            REPLACE(value, '.', '_'),
                            '-',
                            '_'
                        ),
                        '"',
                        '_'
                    ),
                    '/',
                    '_'
                ),
                '#',
                '_'
            ),
            '%',
            '_'
        ),
        '&',
        '_'
    ),
    '''',
    '_'
)
WHERE propertyId = 8 AND value LIKE '%[^a-z0-9_]%';
