- 2 Posts
- 246 Views
just create a query exclude all the account # begin 03%, however, need all the JRNL ID begin WWD%. But some JRNL ID begin WWD% contain account # begin 03%. Is this possible?
@Chie-Huan-Kuan Would %Substring(ACCOUNT,1,2) <> '03' work?
or are you looking for all WWD even with Account Code '03' in which case
%Substring(ACCOUNT,1,2) <> '03' or %Substring(JRNL_ID,1,3) = 'WWD'