>Index On acc_code+dtoc(Date,1) TO SYS(2015) >>
Create CURSOR tj02 (s_no N(7) ,vou_no c(10) ,Date d(8),vou_type c(4) ,acc_code c(7),acc_name c(40),; drcr1 c(2) ,sales_r c(30),vehicle_no c(10),; dr_amount N(10,2),balance N(10,2),vvou_no N(5),dd_amount N(10,2),ssno N(3)) Index On Alltrim(acc_code)+Dtoc(Date,1) Tag xyz Index On acc_code+Dtoc(Date,1) Tag xyz * the best expression Index On acc_code+Dtos(Date) Tag xyz