SELECT '</TD><TD onclick="getimage_ref(this)">'+ALLTRIM(DI.FILE_NAME) , padr(STRTRAN(INDOFILE(DI.FILE_NAME),'-','.'),12,' ') IND_ID ,FAMOFILE(DI.FILE_NAME) FAM_ID,  STR(ROUND(DI.FILE_SIZE* .0009765625,10))+' KB' Size, DI.FILE_DATE ,  DI.PATHFILE , THUMBNAIL(DI.PATHFILE) Thumbnail  FROM C:\APPS\ERGO\DIRHTM.DBF DI



SELECT  padr(STRTRAN(INDOFILE(DI.FILE_NAME),'-','.'),12,' ') IND_ID ,ROUND(VAL(padr(FAMOFILE(DI.FILE_NAME) ,25,' ')),0) FAM_ID ,DI.PATHFILE , THUMBNAIL(DI.PATHFILE) Thumbnail  FROM C:\APPS\ERGO\DIRHTM.DBF DI