Thanks for your answers. Since, I can't have separate column, so I ported data in Foxpro and then I said :
INDEX ON ALLTRIM(SUBSTR(NAME,AT(".",NAME)+1,30)) TO XX
(Here Name is the name of column in table) and XX is the name of index file which foxpro creates.(XX.IDX)