Header Ads Widget

Responsive Advertisement

[mssql] 숫자 천단위 콤마 찍기 ( mssql format number with commas )


REPLACE(CONVERT(VARCHAR, CAST(숫자필드 AS MONEY),1),'.00','');


# 참고  : http://rocabilly.tistory.com/178

댓글 쓰기

0 댓글