CREATE TABLE Table2
(
    KK VARCHAR(100)
)

INSERT INTO Table2
SELECT 'a@abc.com;b@abc.com;c@abc.com;d@abc.com;' UNION
SELECT 'a@abc.comb@abc.com;c@abc.comd@abc.com;'


SELECT * FROM Table2
WHERE LEN(KK) - LEN(REPLACE(KK,';','')) <> LEN(KK) - LEN(REPLACE(KK,'@',''))

------解决方案--------------------

SQL code

select *
from tb
where patindex('%.com[^;]%',col) > 0