>EXEC ('SELECT * FROM #Final WHERE Aged ' + @AgedStatement + ' ' + @ClearStatement + ' ' + @IsHeldStatement + > ' Order by RecordType, SUBSTRING(Account, 12, 8), Account, CFI, Aged, SWDN') > >>
declare @cType varchar(20) Set @cType 'varchar(5)' declare @myNewVar @cType -- How can I do that?Thanks in advance.