Select substring(SPATH from 6 for 200) Path ,Trim(Trim( trim(stock.SStockcode)|| SGroup) || substring(sorgfilename from IIF((OCTET_LENGTH (sorgfilename) -3) < 1 ,1,OCTET_LENGTH (sorgfilename) -3) for 4)) dest FROM
MULTIMEDIA join stock on  WREFID = stock.WStockid  where STYPE = 'STOCK' and  (SPATH like 'link:%' or SPATH like 'file:%') 
 and (SGroup = 'product_full_image' or SGroup = 'product_thumb_image')

and WREFID = <@WSTOCKID@>
