Wildmatch to blank values

[davyqliks]

Hi All,

I am trying to wildmatch to a set value which is working but i have a new requirement to also wildmatch to Blanks in the excel source.

I am trying the following but for the [Invoice no.] with blank, the data are not importing.

WHERE not IsNull([Invoice no.]) and wildmatch ([Account Code],'*61100000000*','*NULL*') ;

Please can you help me to achieve the script for matching to the number '61100000000' and also blanks in [Account Code]

Thank you in advance

Daniel

[sunny_talwar · Accepted solution]

May be try this

WHERE not IsNull([Invoice no.]) and 
(wildmatch ([Account Code],'*61100000000*') or Len(Trim([Account Code])) = 0);

[davyqliks]

Hey,

Thanks so much Sunny, i will try this now and feedback.

Your help is really appreciated.

Daniel

[davyqliks]

This worked perfectly, Thank you so much Sunny,

Daniel