Appendix: Expression mapping
Although FH Standard and FH Enterprise have some functions in common, many FH Standard functions are not supported by FH Enterprise using SQL Server.
The following expressions are the same in standard FH and FH Enterprise.
- CEILING( )
- LOG( )
- LOWER( )
- LTRIM( )
- RIGHT( )
- RTRIM( )
- SOUNDEX( )
- SPACE( )
- STR( )
- STUFF( )
- UPPER( )
The upsizing process converts expressions with the following expression mapping.
| Standard FH Expression | FH Enterprise Expression |
|---|---|
| True (.T.) | 1 |
| False (.F.) | 0 |
| # | < > |
| .AND. | AND |
| .NOT. | NOT |
| .NULL. | NULL |
| .OR. | OR |
| = < | < = |
| = > | > = |
| ASC( ) | ASCII( ) |
| AT( ) | CHARINDEX( ) |
| CDOW( ) | DATENAME(dw, ...) |
| CHR( ) | CHAR( ) |
| CMONTH( ) | DATENAME(mm, ...) |
| CTOD( ) | CONVERT(datetime, ...) |
| CTOT( ) | CONVERT(datetime, ...) |
| DATE( ) | GETDATE( ) |
| DATETIME( ) | GETDATE( ) |
| DAY( ) | DATEPART(dd, ...) |
| DOW( ) | DATEPART(dw, ...) |
| DTOC( ) | CONVERT(varchar, ...) |
| DTOR( ) | RADIANS( ) |
| DTOT( ) | CONVERT(datetime, ...) |
| HOUR( ) | DATEPART(hh, ...) |
| LIKE( ) | PATINDEX( ) |
| MINUTE( ) | DATEPART(mi, ...) |
| MONTH( ) | DATEPART(mm, ...) |
| MTON( ) | CONVERT(money, ...) |
| NTOM( ) | CONVERT(float, ...) |
| RTOD( ) | DEGREES( ) |
| SUBSTR( ) | SUBSTRING( ) |
| TTOC( ) | CONVERT(char, ...) |
| TTOD( ) | CONVERT(datetime, ...) |
| YEAR( ) | DATEPART(yy, ...) |