|
From: Jack B. <Jac...@es...> - 2019-10-10 18:34:36
|
SQL command is (ONLY difference is the % in front of RPT on 2nd select :
SELECT * FROM "VISION"."PUB"."PM_Program"
WHERE "PM_Program"."ProgCode" like 'RPT%' and "PM_Program"."ProgCode" like '%Label%'
UNION
SELECT * FROM "VISION"."PUB"."PM_Program"
WHERE "PM_Program"."ProgCode" like '%RPT%' and "PM_Program"."ProgCode" like '%Label%'
Results are 1 record??
[cid:image001.png@01D57F75.AA616B30]
Jack Brosch
IT Report Developer
Jac...@es...
T:
M:704-622-6995
www.essentra.com
Essentra
,
United States of America
This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful.
If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.
Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra IT Usage policy.
|
