What is the proper syntax for using an if statement in a t-sql where clause
by rhardy
. Updated 16 years ago
I want to filter my results based on the day of week of today’s date. If today is Friday then I want to get results of everything with a date of Sat, Sun & Mon. But if it isn’t Friday then I only want results from tomorrow.