I still need a little help here. Ok I have this string (I'll give you
some syntax for example purposes)

Declare @Table varchar(100)
Set @Table = 'FACT_TABLE1'
Declare @filler char(3)
Set @filler = 'ABC'
Declare @sqlstring varchar(8000)
Declare @sqlparam nvarchar (500)

Set @sqlstring = 'Select field1,@filler1 as field2 from ' + @Table + '
Left outer join dim_table2 on............'
Set sqlparam = ',@filler1 char(3)
Execute sp_executesql sqlstring ,sqlparam ,@filler1 =@filler


For example purposes, let's assume that the total length of what I set
@sqlstring to was 6100 characters.


How to I implicitly convert that string to ntext?