Select
trim('STK_'|| WSTOCKID || '<@EXT@>')  path,
'thumb_' || trim(trim(SDESCRIPTION) || '<@EXT@>')    dest
from
stock
where
Wstockid =  <@WSTOCKID@>
union
Select
trim('STK_'|| WSTOCKID || '<@EXT@>')  path,
'full_' || trim(trim(SDESCRIPTION) || '<@EXT@>')    dest
from
stock
where
Wstockid =  <@WSTOCKID@>
