数据库函数对照表
序号 | 简述 | Access语法 | SqlServer语法 | Oracle语法 | DB2语法 |
01 | 系统时间 | Date() | GETDATE() | SYSDATE |
|
02 | 连接字符串 | & | + | || | + |
03 | 截取字符串 | SubString | SubStr | SubString | SubString |
04 | 小写字符串 | LCase | Lower | Lower | Lower |
05 | 大写字符串 | UCase | Upper | Upper | Upper |
06 | 查找字符串 | InStr | InStr | CharIndex | InStr |
07 | 替换空值 | IIF+IsNull | Coalesce | Nvl | Coalesce |
08 | 条件取值 | IIF | Case+When+Else | DeCode或Case | IIF |
09 | 字段类型转换 | Str、var、…. | Convert或cast | To_Char,To_Number. | GetConvertStr |
10 | 日期字符串 | ‘2004-10-9’ | #2004-10-19# | ‘2004-10-9’ |
|
11 | Like语句函数 | Like ‘101* | Like ‘101%’ | Like ‘101%’ |
|