DataBase
[오라클] TO_NUMER 를 [MSSQL] CONVERT 로
jason.moon
2011. 6. 23. 15:11
[오라클]
TO_NUMBER(COALESCE(L.LYEARELTRCT, 0)) AS LYEARELTRCT,
[MSSQL]
CONVERT(NUMERIC, COALESCE(L.LYEARELTRCT, 0)) AS LYEARELTRCT,
TO_NUMBER(COALESCE(L.LYEARELTRCT, 0)) AS LYEARELTRCT,
[MSSQL]
CONVERT(NUMERIC, COALESCE(L.LYEARELTRCT, 0)) AS LYEARELTRCT,