I defined the variable @strContect as a nvarchar - a unicode varying character variable. The "N" before the empty string just tells SQL Server that the literal is a unicode literal.

Check out the topic Using Unicode Data in the BOL.

-Mike

>Mike,
>
>What is the significance of the N' - as in "SET @strContent = N''"
>
>Thanks, Al
>
>
>>Yes.
>>
>>

>>DECLARE @strContent nvarchar(8000)
>>SET @strContent = N''
>>
>>SELECT @strContent = @strContect + content FROM cache WHERE id=@random
>>SELECT @strContent
>>

>>
>>-Mike