senthilkumar.v (8/13/2008)
select convert(char(4),datename(yyyy,'01/01/2008'))+convert(char(2),datepart (wk,'01/01/2008'))
Perfect... :hehe: Now, try that against Jenny's original request below... 😉
DECLARE @Serial CHAR(12)
SET @Serial = 'SER074400001'
--Jeff Moden
Change is inevitable... Change for the better is not.