Select substring(SPATH from 6 for 200) Path , SUBSTRING(lower(sorgfilename) from 1 for 1) || '/' || 
SUBSTRING(lower(sorgfilename) from 2 for 1) || '/' || lower(sorgfilename)  dest FROM
MULTIMEDIA where Stype = 'STOCK' and  (SPATH like 'link:%' or SPATH like 'file:%') 
and WREFID = <@WSTOCKID@>
