由买买提看人间百态

topics

全部话题 - 话题: compname
(共0页)
l******m
发帖数: 111
1
PROC SQL;
CREATE TABLE TEST AS
SELECT *
FROM YOURDATA
WHERE UPCASE(COMPNAME) LIKE '%preferred%' OR UPCASE(COMPNAME) LIKE '%UNIT%'
OR UPCASE(COMPNAME) LIKE '%WARRANT%' OR UPCASE(COMPNAME) LIKE '%REIT%'
;
QUIT;
(共0页)