PeopleSoft Query Question.

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'