This article provides an example to concatenate a string using select query.
select itemname ||’purchased at Rs.’|| itemprice from item;