YYYY-MM-Mon>
DECLARE @GiGo VARCHAR(46) SELECT @GiGo = '2010-02-Feb' DECLARE @DATE DATETIME SELECT @DATE = LEFT(@GiGo,7) + '-01' -- not needed in this case --SELECT @DATE= DATEADD(mm, DATEDIFF(mm, 0, @DATE)+0, 0) SELECT TOP 1 DATEADD(dd,number,@DATE) FROM master..spt_values WHERE type = 'p' and DATEPART(dw,DATEADD(dd,number,@DATE)) = 7 ORDER BY 1 ASC