Hi Guys,

I suspect not, but I thought I would check with the Gurus..
Can I have an index expression as follows?  

Padr(Trim(First_Name)+' '+Trim(Cust_Name),50,' ')

Perhaps by Add('CustName','Padr(Trim(First_Name)+' '+Trim(Cust_Name),50,' ')',[ixCaseInsensitive],'',icDuplicateByte);

If yes, how please?

Regards & TIA,
Ian

Ian


To the best of my knowledge DBISAM doesn't support calculated indices. The best you can do is create a column, physically store the data and then use it as the index.

However, it does support compound indices - easy to set up using DBSys or SQL - which may do what you want.

Roy Lambert

Ian,

No, that's not possible, Roy is right.

--
Fernando Dias
[Team Elevate]