Filters in Teradata

[iceman23]

Hello,

Given the data below, how will I be able to filter or create a condition/s, given that the PK's are 103895800 and 41775190, what I would like is that if in this group of data ; 'Item Pkg' will be anywhere in the group then the result will have to be NULL.



103895800 41775190 9/15/2009 7:03 8/28/2009 Item Pkg User1
103895800 41775190 9/15/2009 7:04 8/28/2009 Item Pkg User1
103895800 41775190 9/15/2009 7:04 8/28/2009 Resolve User1
103895800 41775190 9/15/2009 7:04 8/28/2009 Item Pkg User2
103895800 41775190 9/15/2009 7:04 8/28/2009 Start Work User2
103895800 41775190 9/15/2009 7:17 8/28/2009 Item Clear System
103895800 41775190 9/15/2009 7:17 8/28/2009 Item Msg System
103895800 41775190 9/15/2009 7:18 8/28/2009 Item Pkg User1
103895800 41775190 9/15/2009 7:19 8/28/2009 Item Pkg User1
103895800 41775190 9/15/2009 7:19 8/28/2009 Resolve User1
103895800 41775190 9/15/2009 7:19 8/28/2009 Item Pkg User2
103895800 41775190 9/15/2009 7:19 8/28/2009 Start Work User2
103895800 41775190 9/15/2009 7:20 8/28/2009 Item Pkg User2
103895800 41775190 9/15/2009 7:20 8/28/2009 Resolve User2



Thanks in advance

[amitpatel66]

Can you provide more insight on your requirement?

[iceman23]

The requirement is that if a match for a certain word/s is within the group of data just like the example above, the result should return 'NULL' or should not return any value at all in the output.

somewhat, I need to determine if a word/s is included in the group and eventually filter that set of PK's and not be included in my result/output once the query is done executing.