I am not sure what the developer is actually trying to achive so i told him to redo his query.....but is it possible to do teh create index in a way so that it ignores the blank spaces?
I think the problem is there has been new fields added and new data is coming in in the table.
Thank you