The Vo2Ado RDD > Appendices > Advantage OleDb functions

Below is a (incomplete) list of VO functions and their translations for the Advantage OleDb Provider. 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%) + LTRIM(CONVERT( ROUND( %1%,%3%),SQL_VARCHAR)),%2%) (*)

SUBSTR(%1%,%2%,%3%)

SUBSTRING(%1%,%2%,%3%)

LEFT(%1%,%2%)

LEFT(%1%,1,%2%)

DTOS(%1%)

CONVERT(YEAR(%1%),SQL_VARCHAR)+ RIGHT('0'+CONVERT(MONTH(%1%),SQL_VARCHAR),2} + RIGHT('0'+CONVERT(DAYOFMONTH(%1%),SQL_VARCHAR),2)

IIF(%1%,%2%,%3%)

** NOT SUPPORTED AS FAR AS WE KNOW **

UPPER(%1%)

UCASE(%1%)

LOWER(%1%)

LCASE(%1%)

TODAY()

CURDATE()

DAY(%1%)

DAYOFMONTH(%1%)

MONTH(%1%)

YEAR(%1%)

CHR(%1%)

CHAR(%1%)

REPL(%1%,%2%)

REPEAT(%1%,%2%)

LEN(%1%)

LENGTH(%1%)

ASC(%1%)

ASCII(%1%)

TRIM(%1%)

RTRIM(%1%)

LTRIM(%1%)

RTRIM(%1%)

ALLTRIM(%1%)

LTRIM(RTRIM(%1%))

(*) The result may be dependant on your windows number format setting