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