Where like

[#1]

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';

[Anil_Babu_Samineni]

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*');

[antoniotiman]

... and MailboxID Like 'BRIA%'

Regards,

Antonio

[#4]

[#5]

[Anil_Babu_Samineni]

Do this condition with Load statement.