>An alternative to using the sp_executesql:
>
>This assumes @Agedstatement is something like '> 30', @Clearstatement is ' AND IsCleared = 1', etc. The parantheses are important.
>
>

>EXEC ('SELECT * FROM #Final WHERE Aged ' + @AgedStatement + ' ' + @ClearStatement + ' ' + @IsHeldStatement +
>	' Order by RecordType, SUBSTRING(Account, 12, 8), Account, CFI, Aged, SWDN')
>
>

>
>

Is it possible to declare a variable with a variable type?

Say,

declare @cType varchar(20)

Set @cType 'varchar(5)'

declare @myNewVar @cType  -- How can I do that?

Thanks in advance.