Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
from table
where not invno like '*DN*';
load
invno,
field2,
field3
from table
where Not WildMatch(invno,'DN*');
Load *
From Table
where not wildmatch(invno,'DN*')