|
||
0
1
UnderTech
T-SQLÀº isnumeric ÇÔ¼ö ÀÌ¿ëÇÏ¸é µË´Ï´Ù.
select case when isnumeric(col) = 0 then \'0\' else col end from TABLE |
0
0
»ç°ü»ýµµ_¾Ù¸®½º
¼ýÀÚÇüÀ» üũÇÏ´Â ÇÔ¼öÀΰ¡º¸³×¿ä.
»ç¿ëÇغ¸´Ï, ¾ø´Â ÇÔ¼ö¶ó°í ¶ß³×¿ä. ¤Ð¤Ð ¸¸¾à, Á¦°¡ ´Ù¸¥ DB¸¦ »ç¿ëÇϰԵȴٸé À¯¿ëÇÏ°Ô ¾µ ¼ö ÀÖÀ» °Í °°½À´Ï´Ù. °¨»çÇÕ´Ï´Ù. :-) |
0
0
°£µµ´Â¿ì¸®¶¥
select COL * 1 from TABLE
±¸±Û½ÅÀ» ¹Ï»ç¿É´Ï´Ù. |
0
0
SSH
mysql or mariadb ¶ó¸é
SELECT \'1.2\' col UNION SELECT \'\' UNION SELECT NULL UNION SELECT \'-3.4\'; SELECT IF(col IS NULL, 0.0, CONVERT(col, DECIMAL(10,6))) FROM (SELECT \'1.2\' col UNION SELECT \'\' UNION SELECT NULL UNION SELECT \'-3.4\') a; |
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | ¸ñ·Ïº¸±â |
NULLÀÌ ³ª¿À¸é ¼ýÀÚÀÌ´Ï ÀÀ¿ëÇؼ ¾²½Ã¸é µË´Ï´Ù.
TRANSLATE¸¦ »ç¿ëÇÏ´Â ÁÁÀº ¹æ¹ýÀ» ¹è¿ü³×¿ä.