你可以使用:
SELECT [User] FROM tab EXCEPT SELECT [User] FROM tab WHERE LEFT(Property,1) IN ('0','1') OR Property LIKE '%-%';
SELECT * FROM <table> WHERE user NOT IN ( SELECT user FROM <table> WHERE Property LIKE '%-%' OR Property LIKE '0%' OR Property LIKE '1%' ) AND Property LIKE '%[^a-zA-Z0-9]%'