• I prefer something I can rely on to work for all cases with dates... my favorite is

    CONVERT(varchar(8),getdate(),112)='20110215'

    because it is easy to remember and there are not special characters and it is always numeric. Not so good if I need a time, but for many processes, (auditing aside) there is no need to check time.

    Jamie