| 函數 | 說明 | 範例 |
|---|
| CONCAT() | 連接字串 | SELECT CONCAT(EMP_NO, EMP_NAM) FROM BSEMPMS |
| VARCHAR() | 轉可變長字串 | SELECT VARCHAR(EMP_NAM, 50) FROM BSEMPMS |
| UCASE() / UPPER() | 轉大寫 | SELECT UCASE(EMP_NAM) FROM BSEMPMS |
| TRUNCATE() / TRUNC() | 截斷數值 | SELECT TRUNCATE(345.6789, 2) FROM BSEMPMS |
| TIME() | 取時間部分 | SELECT TIME('2001-03-19.12.30.123456') FROM BSEMPMS |
| SUBSTR() | 子串 | SELECT SUBSTR('CDNJFDJFJD', 5, 2) FROM BSEMPMS |
| SQRT() | 平方根 | SELECT SQRT(36) FROM BSEMPMS |
| SPACE() | 產生空格 | SELECT SPACE(10) FROM BSEMPMS |
| SECOND() | 取秒數 | SELECT SECOND('18:34:32') FROM BSEMPMS |
| RTRIM() | 去尾部空格 | SELECT RTRIM('COMMENT ') FROM BSEMPMS |
| ROUND() | 四捨五入 | SELECT ROUND(2345.6789, 2) FROM BSEMPMS |
| REPLACE() | 字串替換 | SELECT REPLACE('ROMANDD', 'NDD', 'CCB') FROM BSEMPMS |
| 函數 | 說明 | 範例 |
|---|
| REPEAT() | 重複字串 | SELECT REPEAT('REPEAT', 3) FROM BSEMPMS |
| REAL() | 單精度浮點數 | SELECT REAL(10) FROM BSEMPMS |
| RAND() | 隨機數 | SELECT RAND() FROM BSEMPMS |
| POWER() | 冪運算 | SELECT POWER(2, 5) FROM BSEMPMS |
| POSSTR() | 搜尋子串位置 | SELECT POSSTR('ABCDEFGH', 'D') FROM BSEMPMS |
| NULLIF() | 相等回傳 NULL | SELECT NULLIF(EXP1, EXP2) FROM BSEMPMS |
| NODENUMBER() | 分區號 | SELECT NODENUMBER(EMP_NO) FROM BSEMPMS |
| MOD() | 餘數 | SELECT MOD(20, 8) FROM BSEMPMS |
| LTRIM() | 去前導空格 | SELECT LTRIM(' CDDD') FROM BSEMPMS |
| DOUBLE() | 雙精度浮點數 | SELECT DOUBLE('5678') FROM BSEMPMS |
| EXP() | 指數 | SELECT EXP(2) FROM BSEMPMS |
| FLOAT() | 浮點數 | SELECT FLOAT(789) FROM BSEMPMS |
| FLOOR() | 向下取整 | SELECT FLOOR(88.93) FROM BSEMPMS |
| HEX() | 十六進位 | SELECT HEX(16) FROM BSEMPMS |
