>>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