SQL Concatenate String in Result

Question

Let's say I have the following query:

SELECT anInteger FROM table;

How do I make that query concatenate a url on the front - so each row returned becomes:

'http://aurl.com/something?q=anInteger'

Note it must be the query itself that performs the concatenation - obviously in a situation where you are getting the results into a language you should concatenate in the language.

Answer 1

You would use something like:

SELECT 'http://aurl.com/something?q=' + cast(anInteger as varchar) FROM table;