|
<< Click to Display Table of Contents >> Microsoft Jet Engine Functions |
  
|
Microsoft Jet Engine Functions
|
<< Click to Display Table of Contents >> Microsoft Jet Engine Functions |
|
Below is a (incomplete) list of VO functions and their translations for Microsoft SQL Server. These functions are also built into the RDD
If you find a missing function that you use in your applications, please let us know, so we can add the function to our list
VO Function
|
SQL Function
|
STR(%1%,%2%,%3%)
|
RIGHT(SPACE(%2%)+CSTR(ROUND(%1%,%3%)),%2%) (*)
|
SUBSTR(%1%,%2%,%3%)
|
MID(%1%,%2%,%3%)
|
LEFT(%1%,%2%)
|
LEFT(%1%,1,%2%)
|
DTOS(%1%)
|
FORMAT(%1%,'yyyymmdd')
|
IIF(%1%,%2%,%3%)
|
IIF(%1%,%2%,%3%)
|
UPPER(%1%)
|
UCASE(%1%)
|
LOWER(%1%)
|
LCASE(%1%)
|
TODAY()
|
DATE()
|
DAY(%1%)
|
DAY(%1%)
|
MONTH(%1%)
|
MONTH(%1%)
|
YEAR(%1%)
|
YEAR(%1%)
|
CHR(%1%)
|
CHR(%1%)
|
REPL(%1%,%2%)
|
STRING(%2%,%1%)
|
LEN(%1%)
|
LEN(%1%)
|
ASC(%1%)
|
ASCII(%1%)
|
TRIM(%1%)
|
RTRIM(%1%)
|
LTRIM(%1%)
|
LTRIM(%1%)
|
RTRIM(%1%)
|
RTRIM(%1%)
|
ALLTRIM(%1%)
|
LTRIM(RTRIM(%1%))
|
+
|
+
|
(*) The result may be dependant on your windows number format setting