Logic Help

[abhaysingh]

Hi,

I have few invoices start from DN like DN14/2014/123,, I don't want to include in my data.. how I can put where condition in that case

load invno,

field2,

field3

from table where invno<> '*DN*'

not working...

pls suggest

[swuehl]

from table

where not invno like '*DN*';

[MK_QSL]

load

     invno,

     field2,

     field3

from table

where Not WildMatch(invno,'DN*');

[Kushal_Chawda]

Load *

From Table

where not wildmatch(invno,'DN*')