Sql adding a string and number and displaying it as a single column

Question

I am trying to take a column that stores a id # for a webpage on a site and store it with the full url.

If the Article ID is 5. I want it to store return something like this

<a href="http://website.com/5">5</a>

What I am trying to do is combine a string put in the search and a number to make a URL for the column. I know this syntax is incorrect but I can not find anyway on how to do it.

SELECT
CASE                                                                        
WHEN m_tableFoo.articleId = '0' THEN                                
    'Not Applicable'                                                    
ELSE '<a href="http://website.com/'+m_tableFoo.articleId+'/">'+m_tableFoo.articleId+'</a>' 
END AS articleID
from m_tableFoo

I have tried searching the web and Stack Overflow, but I am not sure if my search wording is incorrect or my description.

Take a look at: http://stackoverflow.com/questions/278189/what-is-the-string-concatenation-operator-in-oracle — DWright, Jan 21 '13 at 16:44
You will need to convert the articleID to a string, and also the concatenation operator in Oracle is `||` — GarethD, Jan 21 '13 at 16:45
thanks I'll take a look at that, that seems to be the correct wording. — Halfwarr, Jan 21 '13 at 16:46

score 16 · Accepted Answer · answered Jan 21 '13 at 16:46

16

oracle uses || for concatenation, not +. You will probably also need to TO_CHAR the article ids

answered Jan 21 '13 at 16:46

paul

21,653
1
53
54

2

Just to complete this statement: `||` is the SQL standard for string concatenation and besides MySQL and Microsoft all DBMS vendor comply with that. – Jan 21 '13 at 17:20

Sql adding a string and number and displaying it as a single column

1 Answers1