>>>>index on ; >>>>town+UPPER(PADR(TRIM(IIF(AT("=",OWNER1,2)>0,SUBSTR(OWNER1, ; >>>>AT("=",OWNER1)+1,AT("=",OWNER1,2)-AT("=",OWNER1)-1),SUBSTR(OWNER1,AT("=",OWNER1)+1)))+ ; >>>>IIF(AT("=",OWNER1)>0,LEFT(OWNER1,AT("=",OWNER1)-1),""),25)) tag name1 >>>>>>>
*!****************************************************************************** function GetFLNameWithComma * Description.......: Function returns LastName, First name + Initial * Calling Samples...: GetFLNameWithComma(buyer1) * Parameter List....: tcName * Created by........: Nadya Nosonovsky 08/22/2000 05:10:15 PM ******************************************************************** lparameter tcName local lcFName, lcLName, lnPosEqual1, lnPosEqual2, lcFullName lcLName=alltrim(m.tcName) lnPosEqual1=at('=',m.lcLName) lnPosEqual2=at('=',m.lcLName,2) lcFName="" if m.lnPosEqual1>0 lcFName=left(m.lcLName,m.lnPosEqual1-1) lcLName=substr(m.lcLName,m.lnPosEqual1+1,; iif(m.lnPosEqual2>0,m.lnPosEqual2-m.lnPosEqual1-1,25)) endif lcFullName=m.lcLName+iif(!empty(m.lcFName),', ','')+m.lcFName return m.lcFullNameIf I put index on town+padr(GetFLNameWithComma(owner1),26) tag name1 it would mean, what we can use our tables only inside the application or with path set properly to the storage of this function...