how to remove value not required

[bsbernabe]

Hello There,

I create some report that some data start at 333 and 777 is unwanted or not required my concern is how can i remove at IDNo field start at 333 and 777 in my load script, list below is my sample data from db.

IDNo

777abcdefg00000654349

853abcdefg00000614349

072abcdefg10000647350

802abcdefg10000064951

333abcdefg10000064356

333abcdefg10000064382

777abcdefg10000064358

Best Regards,

Bing

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

Load IDNo from table where not wildmatch(IDNo, '333*', '777*')

[bsbernabe]

Thank you for fast support highly appreciated.