その他の関数

Excel、MDB

 ```select Round(123.456) as 四捨五入1 ,Round(123.456,2) as 四捨五入2 ,Fix(123.456) as 切捨て ,Format(123456,'#,###') as 数値編集1 ,Format(123456,'#,##0') as 数値編集2 ,Instr('ABCDEFG','CDE') as 文字列検索 ,UCase('abc') as 大文字 ,LCase('ABC') as 小文字 ,10 MOD 4 as 余り ```

123123.46123123,456123,4563ABCabc2

SQLServer

 ```select ROUND(123.456,0) as 四捨五入1 ,ROUND(123.456,1) as 四捨五入2 ,ROUND(123.456,-1) as 四捨五入2 ,ROUND(123.456,0,1) as 切捨て1 ,ROUND(123.456,2,1) as 切捨て2 ,ROUND(123.456,-1,1) as 切捨て3 ,PATINDEX('%CDE%', 'ABCDEFG') as 文字列検索 ,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換 ,UPPER('abc') as 大文字 ,LOWER('ABC') as 小文字 ,10 % 4 as 余り ,REPLACE(CONVERT(VARCHAR(20),CONVERT(money,123456),1),'.00','') as 整数編集 ```

123123.5120123123.451203ABxxxFGABCabc2123,456

MySQL

 ```select ROUND(123.456) as 四捨五入1 ,ROUND(123.456,2) as 四捨五入2 ,ROUND(123.456,-1) as 四捨五入3 ,TRUNCATE(123.456,1) as 切捨て1 ,TRUNCATE(123.456,-1) as 切捨て2 ,LPAD('ABC','6','0') as 埋め込み1 ,RPAD('ABC','6','0') as 埋め込み2 ,INSTR('ABCDEFG','CDE') as 文字列検索 ,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換 ,UPPER('abc') as 大文字 ,LOWER('ABC') as 小文字 ,MOD(10,4) as 余り ```

PostgreSQL

 ```select ROUND(123.456) as 四捨五入1 ,ROUND(123.456,2) as 四捨五入2 ,ROUND(123.456,-1) as 四捨五入3 ,TRUNC(123.456) as 切捨て1 ,TRUNC(123.456,2) as 切捨て2 ,TRUNC(123.456,-1) as 切捨て3 ,TO_CHAR(123456,'999,999') as 数値編集 ,TO_CHAR(123,'00000') as 先行ゼロ編集 ,TO_CHAR(12345,'FM9999999999') as 文字列へ変換 ,LPAD('ABC','6','0') as 埋め込み1 ,RPAD('ABC','6','0') as 埋め込み2 ,POSITION('CDE' in 'ABCDEFG') as 文字列検索 ,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換 ,UPPER('abc') as 大文字 ,LOWER('ABC') as 小文字 ,MOD(10,4) as 余り ```

123123.46120123123.45120123,456123

12345000ABCABC0003ABxxxFGABCabc2

Oracle

 ```select ROUND(123.456) as 四捨五入1 ,ROUND(123.456,2) as 四捨五入2 ,ROUND(123.456,-1) as 四捨五入3 ,TRUNC(123.456) as 切捨て1 ,TRUNC(123.456,2) as 切捨て2 ,TRUNC(123.456,-1) as 切捨て3 ,TO_CHAR(123456,'999,999') as 数値編集 ,TO_CHAR(123,'00000') as 先行ゼロ編集 ,LPAD('ABC','6','0') as 埋め込み1 ,RPAD('ABC','6','0') as 埋め込み2 ,INSTR('ABCDEFG','CDE') as 文字列検索 ,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換 ,UPPER('abc') as 大文字 ,LOWER('ABC') as 小文字 ,MOD(10,4) as 余り from dual ```

 infoboard   管理者用 ツイート

JSライブラリ