Ignore Blank Issue
Posted: February 21st, 2022, 4:28 pm
When running the inquire, keys are set to ignore blanks as shown in the screenshot below. Query output shows otherwise.
Code: Select all
select SDDOCO, SDDCTO, SDLITM, SDDSC1, SDUORG, SDSOQS, SDSOBK, CAST(SDUPRC / 10000.00 AS DECIMAL(9,2)) as SDUPRC, SDVR01, SDTRDJ, SDDRQJ, SDPPDJ, SDLNID, SDEUSE, SDKCOO from JDE_Development.TESTDTA.F4211 WHERE SDSHAN = '' AND SDDOCO = '' AND SDLITM = '' AND UPPER(SDDSC1) like '%%' AND SDVR01 = '' AND SDTRDJ = '' AND SDDRQJ = '' AND SDPPDJ = '' AND SDSOBK > 0 - 2022-02-21_16-26-09.png (28.18 KiB) Viewed 1184 times
- 2022-02-21_16-26-09.png (28.18 KiB) Viewed 1184 times