MS SQL Compare Date Ranges With Start Date to End Date

PRINT CAST(CAST(’20080513’ AS DATETIME) AS VARCHAR) + ’ <= ’ + CAST(GETDATE() AS VARCHAR) PRINT CAST(CAST(’20080513’ AS DATETIME) AS VARCHAR) + ’ >= ’ + CAST(GETDATE() AS VARCHAR) IF CAST(’20080513’ AS DATETIME) <= GETDATE() AND CAST(’20080513’ AS DATETIME) >= DATEADD(d, -1, GETDATE()) BEGIN PRINT ’T’ END ELSE PRINT ’F’