Hey all

I've inherited a system with SQL stored procedures and functions. I want to clarify my understanding.

Would this ...

select @startdate = dbo.myfunction(@startdate)
select @enddate = dbo.myfunction(@enddate)

SELECT * from table where datefield between @startdate and @enddate

be better than this...

SELECT * from table where datefield between dbo.myfunction(@startdate) and dbo.myfunction(@enddate)