IBExpert UDF Functions
<< IBExpertDemoDB | Documentation | Firebird Special Edition by IBExpert >>
IBExpert UDF Functions
... new IBExpert software product coming soon! Documentation currently in work.''
IBExpert UDF Functions are a set of internal functions implemented to behave as their UDF counterparts.
String UDFs
- F_CRLF
- F_LF
- F_SPACE
- F_DQM
- F_SQM
- F_DSQM
- F_TAB
- F_LEFT (F_LEFT4, F_LEFT8) F_BIGLEFT U_LEFT(U_LEFT4, U_LEFT8)
- F_MID (F_MID4, F_MID8) F_BIGMID U_MID(U_MID4, U_MID8) F_COPY F_STRCOPY
- F_RIGHT (F_RIGHT4, F_RIGHT8) F_BIGRIGHT U_RIGHT(U_RIGHT4, U_RIGHT8)
- F_SUBSTR (F_SUBSTR4, F_SUBSTR8) F_BIGSUBSTR U_SUBSTR F_STRSUB F_STRPOS
- F_SUBSTRN (F_SUBSTR) U_SUBSTR F_STRSUBN
- F_STRRM U_STRRM
- F_LTRIM (F_LTRIM4, F_LTRIM8) F_BIGLTRIM
- F_RTRIM (F_RTRIM4, F_RTRIM8) F_BIGRTRIM
- F_LRTRIM (F_LRTRIM4, F_LRTRIM8) F_BIGLRTRIM
- F_PADLEFT U_PADLEFT F_RPADLEFT
- F_PADRIGHT U_PADRIGHT F_RPADRIGHT
- F_PADCENTER U_PADCENTER
- F_LINEWRAP U_LINEWRAP
- F_REPLACE (F_REPLACE4, F_REPLACE8) F_BIGREPLACE
- F_REPLACESTRING (F_REPLACESTRING4, F_REPLACESTRING8) F_BIGREPLACESTRING U_REPLACESTRING
- F_CONVERTSYMBOLS U_CONVERTSYMBOL
- F_REVERSE U_REVERSE
- F_STRIPSTRING F_BIGSTRIPSTRING U_STRIPSTRING
- F_STRIPSTRINGHOLD F_HOLDSTRING F_BIGSTRIPSTRINGHOLD U_STRIPSTRINGHOLD
- F_REPEATTRIM (REPEATTRIM, LONGREPEATTRIM) U_REPEATTRIM
- F_STRREPEAT
- F_STROFCHAR
- F_STRSTUFF U_STRSTUFF
- F_PRED U_PRED
- F_SUCC U_SUCC
- F_LOWER F_ANSILOWERCASE U_LOWER
- F_UPPER F_ANSIUPPERCASE U_UPPER
- F_PROPERCASE U_PROPERCASE
- F_CHARACTER U_CHR
- F_ORD U_ORD
- F_ROT13
- F_GENERATESNDXINDEX F_SOUNDEX
- F_TELEFONNR
- F_DIGITS
- F_STR2EXCEL
- F_RC
- F_EQUALSTRING
- F_STRCMP U_STRCMP
- F_FINDWORD U_FINDWORD
- F_WORDNUM
- F_FINDNTHWORD
- F_FINDWORDINDEX
- F_FINDWORDINDEXN (F_FINDWORDINDEX)
- F_STRINGLENGTH(..4, ..8, ..32) F_BIGSTRINGLENGTH U_STRINGLENGTH
- F_STRINGLISTITEM
- F_WORDCOUNT
- F_RWORDCOUNT
- F_STRINGCOUNT F_RSTRINGCOUNT
- F_DOMAINFROMEMAIL
...
Date and Time UDFs
- F_ADDYEAR
- F_ADDMONTH
- F_ADDWEEK
- F_ADDDAY
- F_ADDHOUR
- F_ADDMINUTE
- F_ADDSECOND
- F_INCDATE
- F_INCDATETIME
- F_ADDPERIOD
- F_SUBPERIOD
- F_AGEINYEARS
- F_AGEINYEARSN
- F_AGEINMONTHS
- F_AGEINMONTHSN
- F_AGEINWEEKS
- F_AGEINWEEKSISO
- F_AGEINWEEKSN
- F_AGEINWEEKSNISO
- F_AGEINDAYS
- F_AGEINDAYSN
- F_AGEINWORKINGDAYS
- F_AGEINHOURS
- F_AGEINHOURSN
- F_AGEINMINUTES
- F_AGEINMINUTESN
- F_AGEINSECONDS
- F_AGEINSECONDSN
- F_AGEINYEARSTHRESHOLD
- F_AGEINYEARSTHRESHOLD
- F_AGEINMONTHSTHRESHOLDN
- F_AGEINMONTHSTHRESHOLDN
- F_AGEINWEEKSTHRESHOLD
- F_AGEINWEEKSTHRESHOLDISO
- F_AGEINWEEKSTHRESHOLDN
- F_AGEINWEEKSTHRESHOLDNISO
- F_AGEINDAYSTHRESHOLD
- F_AGEINDAYSTHRESHOLDN
- F_AGEINWORKINGDAYSTHR
- F_AGEINHOURSTHRESHOLD
- F_AGEINHOURSTHRESHOLDN
- F_AGEINMINUTESTHRESHOLD
- F_AGEINMINUTESTHRESHOLDN
- F_AGEINSECONDSTHRESHOLD
- F_AGEINSECONDSTHRESHOLDN
- F_YEARSBETWEEN
- F_MONTHSBETWEEN
- F_WEEKSBETWEEN
- F_WEEKSBETWEENISO
- F_DAYSBETWEEN
- F_WORKINGDAYSBETWEEN
- F_HOURSBETWEEN
- F_MINUTESBETWEEN
- F_INDMINUTESBETWEEN
- F_INDMINUTESBETWEENTHR
- F_INDMINUTESBETWEENTHRIB
- F_SECONDSBETWEEN
- IF_DLST: Daylight saving time
- F_DAYOFYEAR F_EXTRACTYEARDAY
- F_DAYOFMONTH
- F_DAYOFWEEK F_EXTRACTWEEKDAY F_DOW
- F_DAYSOFMONTH
- F_LASTDAY
- F_FIRSTDAYQUARTER
- F_LASTDAYQUARTER
- F_FIRSTDAYMONTH
- F_LASTDAYMONTH
- F_FIRSTDAYWEEK
- F_LASTDAYWEEK
- F_FIRSTDAYWEEKISO
- F_LASTDAYWEEKISO
- F_FIRSTDAYWOY
- F_LASTDAYWOY
- F_FIRSTDAYKW
- F_LASTDAYKW
- F_FIRSTDAYLASTQUARTER
- F_LASTDAYLASTQUARTER
- F_FIRSTDAYLASTMONTH
- F_LASTDAYLASTMONTH
- F_FIRSTDAYLASTWEEK
- F_LASTDAYLASTWEEK
- F_FIRSTDAYLASTWEEKISO
- F_LASTDAYLASTWEEKISO
- F_FIRSTDAYNEXTQUARTER
- F_LASTDAYNEXTQUARTER
- F_FIRSTDAYNEXTMONTH
- F_LASTDAYNEXTMONTH
Functions still to be implemented
...
Functions that are impossible to implement or they don't have sense in current Firebird
String UDFs
...
back to top of page
<< IBExpertDemoDB | Documentation | Firebird Special Edition by IBExpert >>
Any comments? Send an email to register@ibexpert.biz
COPYRIGHT © 2002-2024 HK-Software, IBExpert Ltd. All rights reserved.
All IBExpert brand and product names are trademarks or registered trademarks of IBExpert Ltd in Malta and other countries. InterBase, Delphi, CodeGear, C++Builder, Delphi/400, Delphi for PHP and JBuilder are trademarks or registered trademarks of Embarcadero Technologies Inc. in the United States and other countries. Firebird is a registered trademark of the FirebirdSQL Foundation. Turbo Pascal is a registered trademark of Borland International, Inc. Sun, Java, JavaScript and Solaris are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and other countries. UNIX is a registered trademark in the United States and other countries, exclusively licensed through “The Open Group”. Oracle is a registered trademark of Oracle Corporation in the United States and other countries. All Microsoft brand and product names are trademarks or registered trademarks of Microsoft Corporation in the United States and other countries. AS/400, DB2, IBM, Informix and iSeries are trademarks or registered trademarks of IBM Corporation in the United States and other countries. Linux is a registered trademark of Linux Torvalds. dBASE is a trademark of dataBased Intelligence, Inc. Skype is a registered trademark of Skype Ltd., in the United States and other countries. All other product names mentioned herein and throughout the entire web site are trademarks of their respective owners.
