SQL Concatenate String in Result

You would use something like:

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

It will depend on the RDBMS you are using:

MySQL:

SELECT concat(anInteger, " your string goes here") FROM table;

PostgreSQL:

SELECT anInteger || " your string goes here";

Oracle:

Same as PostgreSQL

Related