|
<< Click to Display Table of Contents >> Microsoft SQL Server Functions |
  
|
Microsoft SQL Server Functions
|
<< Click to Display Table of Contents >> Microsoft SQL Server 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%)
|
STR(%1%,%2%,%3%)
|
SUBSTR(%1%,%2%,%3%)
|
SUBSTRING(%1%,%2%,%3%)
|
LEFT(%1%,%2%)
|
LEFT(%1%,1,%2%)
|
DTOS(%1%)
|
CONVERT(char(8), %1%,112)
|
IIF(%1%,%2%,%3%)
|
CASE WHEN %1% THEN %2% ELSE %3% END
|
UPPER(%1%)
|
UPPER(%1%)
|
LOWER(%1%)
|
LOWER(%1%)
|
TODAY()
|
GETDATE()
|
DAY(%1%)
|
DAY(%1%)
|
MONTH(%1%)
|
MONTH(%1%)
|
YEAR(%1%)
|
YEAR(%1%)
|
CHR(%1%)
|
CHAR(%1%)
|
REPL(%1%,%2%)
|
REPLICATE(%1%,%2%)
|
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%))
|
+
|
+
|