Select 
substring(SPATH from 6 for 200) Path,
substring(sorgfilename from 1  for  OCTET_LENGTH (sorgfilename) -4)   || 
substring(sorgfilename from IIF((OCTET_LENGTH (sorgfilename) -3) < 1 ,1,OCTET_LENGTH (sorgfilename) -3) for 4)  dest,
sgroup 

FROM MULTIMEDIA 
join groups on wrefid = wgroupid 

where 
WREFID = <@WGROUPID@> and 
STYPE = 'GROUP' and 
(SPATH like 'link:%' or SPATH like 'file:%') and 
(SGROUP = 'categories_image')