Thursday, April 23, 2009

SQL2005 - Formato de miles

SELECT SUBSTRING(CONVERT(VARCHAR,CAST(UUVENDIDAS AS MONEY),1),0,LEN(CONVERT(VARCHAR,CAST(UUVENDIDAS AS MONEY),1))-2) FROM PRODUCTO

No comments: