Performance wise I know we should avoid having scalar functions on the left side of the equal in the where clause. Anybody have an idea on how to avoid it in something like below?
Thanks
Selectmin(sdatetime) as FirstDate
from dbo.Meetings (nolock)
where iscancelled=0and roomclosed=0and isblock=0andsubstring(scheduledBy,1,4)<>'TEST'andsubstring(scheduledBy,1,3)<>'CQI'