Stored Procedure - Concatenate

Hi,
I'm trying to do a pretty simple concatenation in a stored procedure, but from some reason it doesn't work:
please help!
DROP PROC Temp;
GO
CREATE PROC Temp
(
@SearchStr nvarchar(100)
)
AS
BEGIN
SET NOCOUNT ON

DECLARE Eli_Cursor CURSOR FOR
Select Name1
From [Northwind].[dbo].[Eli];
Declare @FileName nvarchar(40);
Declare @tmp nvarchar(40);
SET @FileName = '';
SET @tmp = ''
OPEN Eli_Cursor;
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Eli_Cursor INTO @FileName;
SET @tmp = @FileName+'.jpg';
update [Northwind].[dbo].[Eli]
set Name3 = @tmp
where Name1 = @FileName;
END

CLOSE Eli_Cursor;
DEALLOCATE Eli_Cursor;
END
go

there is no error whatsoever. I just don't get the required output which is: Name3 (a field in the table) should be populated with a new value that shoud be: value of Name1+'.jpg', in this case: 'ABC.jpg'
Name 1 and Name3 are fields in the table
Thanks
Eli

this is exactly what I did, but from some reason it didn't work. now it's working, though. I must have missed something.
tnx very much
Eli

Glad to hear the issue is resolved. I want to take a step back. If the value of name3 is always equal to Name1 + '.jpg', Whydo you need this column name3, and update the entire table? You can always refer it as Name1+'.jpg'. Is this something you gave as a simplified example?

it's just a simple example. the real system is way complex.
thanks again.
Eli

I think it is a cast problem. Verify the type of each columns and variables you use.
Try this : CAST(@variable as varchar(40)) for example.

Just to update those who haven;t seen yet, when you specify a variable as varchar (without giving the length) SQL Server will take the default of varchar(30).

Thanks to Frank and Madivanan, who brought clarity to my post. This is what exactly I was intended to say; As we were discussing about CASTing, I was planning to say that if we specify varchar without specifying the length {in cast operation} it will end up to a cast of varchar(30). While writing I missed the words "In cast operation". Thank you again to both of you guys, you have taought me a good lesson on effective communication.
This is the main reason I love this forum; I share what I know and I learn something what I do not know.