Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
just a simple question. i have a field, which have data such as A10001, 120111. i need to get rid/exclude of those A* data for that particular field when i am doing the loading script. how should i write...?
Load
ID
Where Not MixMatch(ID, 'A*');
will this work?????
rgds
jim
May be try this:
Load
ID
Where Not WildMatch(ID, 'A*');
OR
Load
ID
Where Num(ID);
May be try this:
Load
ID
Where Not WildMatch(ID, 'A*');
OR
Load
ID
Where Num(ID);
Hi Vish,
i ahve used this Where Not WildMatch(ID, 'A*');
and it work.
thank you.