Basic SQL problem (Conversion failed when converting the varchar value '' to data type int.)

Question

4.00/5 (1 vote)

See more:

SQL-Server-2005

Hi,

I'm trying to get this fairly easy query to work but, as always with me and SQL, it doesn't work.

(
SELECT 
   (
      CASE WHEN FotoId IS NULL 
      THEN 'Some URL'
      ELSE 'Some URL' + FotoId + '-100-100-9.jpg'
      END
   ) AS FotoURL
FROM Fotos
WHERE ProfielId = 123

ERROR:

Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'Some URL' to data type int.

Posted 23-Apr-12 22:00pm

willempipi

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2012-04-23T22:05:00

Solution 1

It's because you are trying to concatenate a string and an int - you need to convert the int to a string:

SQL

ELSE 'Some URL' + CONVERT(NVARCHAR(10), FotoId) + '-100-100-9.jpg'

Posted 23-Apr-12 22:05pm

OriginalGriff

Comments

willempipi 24-Apr-12 4:06am

I hate SQL

OriginalGriff 24-Apr-12 4:10am

It's error messages could use a good kicking, I admit!

Basic SQL problem (Conversion failed when converting the varchar value '' to data type int.)

1 solution

Solution 1

Add your solution here

Preview 0

Basic SQL problem (Conversion failed when converting the varchar value '' to data type int.)

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us