Exclude content of field that starts with a specific letter

[#1]

Hello,

I'm trying to exclude from my load all data of a field that start with the letter 'E' (field name is Account, see below).

I used wildmatch but it doesn't work. Here is part of my script.

Load

PM                                                                as [AP Payment Type],

Type                                                              as [AP Type],

[Clrng doc.]                                                    as [AP Clearing Doc],   

DocumentNo                                                  as [AP Document Number],

Account                                                         as [AP Account],

[G/L]                                                             as [AP Payment GL Acct],

Reason                                                          as [AP Late Payment Reason]                      

  FROM

  [$(RootDir_Data_Country_AP)$(l_Date)_monthlysummary.xlsx]

  (ooxml, embedded labels)

  Where Account <> WildMatch(Account,'E*')

  ;

Any idea ?

Thank you

[swuehl · Accepted solution]

  Where not  WildMatch(Account,'E*')

[maxgro]

where not Account like 'E*';

where not upper(left(Account,1)) = 'E';

[jagan]

HI,

Try this

Where NOT  Upper(Account) WildMatch(Account,'E*');

OR

WHERE NOT  Upper(Account)  LIKE 'E*';

Hope this helps you.

Regards,

jagan.

[jagan]

OR

WHERE Upper(Left(Account, 1)) <> 'E';

Hope this helps you.

Regards,

jagan.

[#6]

Thank you very much guys.

All your solutions work.