loading script - how to exclude data that start with "A..."

[jim_chan]

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

[vishsaggi · Accepted solution]

May be try this:

Load

ID

Where Not WildMatch(ID, 'A*');

OR

Load

ID

Where Num(ID);

[jim_chan]

Hi Vish,

i ahve used this Where Not WildMatch(ID, 'A*');

and it work.

thank you.