Home » SQL & PL/SQL » SQL & PL/SQL » join strings
join strings [message #195359] Thu, 28 September 2006 04:14 Go to next message
steffeli
Messages: 112
Registered: July 2006
Senior Member
Hello

How can I join the string "Product: " in front of the param?

I tried the code below, but it doesn't work.

select 'Product: ' param
from tab


Thanks
Stefan
Re: join strings [message #195364 is a reply to message #195359] Thu, 28 September 2006 04:34 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
select 'Product: '||param
from tab

or
select concat('Product: ',param)
from tab
Previous Topic: MAXEXTENTS
Next Topic: Replace
Goto Forum:
  


Current Time: Fri Dec 02 22:51:40 CST 2016

Total time taken to generate the page: 0.14806 seconds