Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
WHERE not IsNull([Invoice no.]) and
(wildmatch ([Account Code],'*61100000000*') or Len(Trim([Account Code])) = 0);
May be try this
WHERE not IsNull([Invoice no.]) and
(wildmatch ([Account Code],'*61100000000*') or Len(Trim([Account Code])) = 0);
Hey,
Thanks so much Sunny, i will try this now and feedback.
Your help is really appreciated.
Daniel
This worked perfectly, Thank you so much Sunny,
Daniel