How to Drop field values while loading script

[nihhalmca]

Hi All,

How to Drop field values while loading script

Ex: Field has values like A,B,C,D,E,F.....Z, i want to drop filelds 'C','D','E' from the field without using of WHERE/WHERE exists condition.

Thanks,

Nihhal.

[nihhalmca]

If field has values [Product],[Product Type]...Purgechar remove both "Product".

[Anonymous]

Hi,

I have few questions:

1. Any specific reason for not using where/ where exists?
2. Is it you want the records for 'C', 'D', 'E', but want to replace value 'C', 'D', 'E' with some other value?