>>with 26 Miliion record with null value the better solution is
>>VARCHAR(100) with Sparse attribute
>
>Thanks for the info but I need the index as upcoming new records will have data on that field.
You can create index (filtered) on sparse column
--sb--