Sara_DBA (8/13/2008)
SELECT CONVERT(VARCHAR,GetDate(),112) 😛
Heh...ok, Sara... if you read Jenny's original request, tell me how your code converts the following, posted in that original request, to a date. 😛
DECLARE @Serial CHAR(12)
SET @Serial = 'SER074400001'
--Jeff Moden
Change is inevitable... Change for the better is not.