// Selection of image data in the multimedia table
Select substring(SPATH from 6 for 200) Path ,trim(trim(SSTockCode) ||  SGroup ||
substring(sorgfilename from IIF((OCTET_LENGTH (sorgfilename) -3) < 1 ,1,OCTET_LENGTH (sorgfilename) -3) for 4)) dest,sgroup FROM
MULTIMEDIA join stock on wrefid = wstockid where WREFID = <@WSTOCKID@> and STYPE = 'STOCK' and (SPATH like 'link:%' or SPATH like 'file:%') 
and (SGROUP = 'product_thumb_image' or SGROUP = 'product_full_image')
