序号 | 简述 | Access语法 | SqlServer语法 | Oracle语法 | DB2语法 | 解决方案 |
01 | 系统时间 | Date()/Now() | GETDATE() | SYSDATE | GetSysTimeStr | |
02 | 连接字符串 | & | + | || | + | GetConcatStr |
03 | 截取字符串 | Mid | SubString | SubStr | SubString | GetSubStr |
04 | 小写字符串 | LCase | Lower | Lower | Lower | GetLowerStr |
05 | 大写字符串 | UCase | Upper | Upper | Upper | GetUpperStr |
06 | 查找字符串 | InStr | CharIndex | CharIndex | InStr | GetFindStr |
07 | 替换空值 | IIF+IsNull | Coalesce | Nvl | Coalesce | GetNullStr |
08 | 条件取值 | IIF | Case+When+Else | DeCode或Case | IIF | GetCaseStr |
09 | 字段类型转换 | Str、var、…. | Convert或cast | To_Char,To_Number. | GetConvertStr | |
10 | 日期字符串 | ‘2004-10-9’ | #2004-10-19# | ‘2004-10-9’ | GetDateStr | |
11 | 最大值加1 | GetNextNumStr | ||||
12 | Like语句函数 | Like ‘101*’ | Like ‘101%’ | Like ‘101%’ | GetLikeStr | |
13 | 日期比较 | DateDiff('d',....... | DateDiff(d,...... |
10-11
10-11
10-11
10-11