F_DOMAINFROMEMAIL

<< F_STRINGCOUNT F_RSTRINGCOUNT | IBExpert UDF Functions | F_ADDYEAR >>

F_DOMAINFROMEMAIL

 
  • function from adhoc
  • Compatible with UTF-8
  • Input VARCHAR(254) eMail-String
  • Output VARCHAR(254) from eMail substituted domain

Example

 SELECT 'ibexpert.com' AS ISCORRECT, F_DOMAINFROMEMAIL('info@ibexpert.com') FROM RDB$DATABASE;

Expected results:

 ISCORRECT    F_DOMAINFROMEMAIL                                                                                                                                    
 ============ ==================================================================
 ibexpert.com ibexpert.com  

Example

 SELECT NULL AS ISCORRECT, F_DOMAINFROMEMAIL(NULL) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_DOMAINFROMEMAIL                                                                                                                                       
 ========= ===============================================================================
 <null>    <null>                

back to top of page
<< F_STRINGCOUNT F_RSTRINGCOUNT | IBExpert UDF Functions | F_ADDYEAR >>