using a VALUE + a STRING as an ALIAS?

Hi,

I'd like to translate this from Access SQL to 'true' SQL:

SELECT "http:/mydomain/" & [Image] AS image_url

I've tried several things but SQL Server doesn't accept it.

How can I add this string to the value of that field?

Thank you very much!

Jerome

Change double quotes to single quotes. Also change & to +

SELECT 'hello' + colname AS image_url FROM ...

Be careful if the column allow NULL, which would result in the concatenated value being NULL (NULL
propagates). If you need to change that, take a look at functions such as ISNULL() and COALESCE().

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"Jerome" wrote in message

> Hi,
>
> I'd like to translate this from Access SQL to 'true' SQL:
>
> SELECT "http:/mydomain/" & [Image] AS image_url
>
> I've tried several things but SQL Server doesn't accept it.
>
> How can I add this string to the value of that field?
>
> Thank you very much!
>
> Jerome