....si nu uita sa adaugi apostroafele necesare - de exemplu:
DECLARE @str varchar(100)
SET @str = 'SELECT * FROM Category WHERE CreatedOn BETWEEN ' + '''' + CONVERT(varchar(25), @date, 101) + '''' +.....