topic Where like in QlikView

Where like

Tue, 27 Jun 2017 17:08:38 GMT

What can I use instead of a "like"

All the mailbox ID that I need start with BRIA

FROM eRx.dbo.eRxMessages

Where ProcessedOn >= '2017-06-18 00:00:00.000'
and Direction = 'I'
and MsgType = 'NEWRX'
and MailboxID LIKE 'BRIABRNM','BRIAGENE','BRIAPALO','BRIAPHSTV','BRIAPRES','BRIAWDSD','BRIADSD','BRIAEST','BRIAWITRVS';

Re: Where like

Anil_Babu_Samineni — Tue, 27 Jun 2017 17:11:30 GMT

May be like below

FROM eRx.dbo.eRxMessages

Where ProcessedOn >= '2017-06-18 00:00:00.000'
and Direction = 'I'
and MsgType = 'NEWRX'
and WildMatch(MailboxID, 'BRIA*');

Re: Where like

antoniotiman — Tue, 27 Jun 2017 17:13:56 GMT

... and MailboxID Like 'BRIA%'

Regards,

Antonio

Re: Where like

Tue, 27 Jun 2017 17:14:22 GMT

Re: Where like

Tue, 27 Jun 2017 17:15:58 GMT

Re: Where like

Anil_Babu_Samineni — Tue, 27 Jun 2017 17:16:27 GMT

Do this condition with Load statement.