https://wiki.ispirer.com/ 2026-04-07T10:43:45+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/char-length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - CHAR_LENGTH Function Informix - CHAR_LENGTH Syntax CHAR_LENGTH() Description CHAR_LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN IBM DB2 LENGTH MySQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/initcap?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - INITCAP Function Informix - INITCAP Syntax INITCAP() Description INITCAP function returns string with the first letter of each word in uppercase Equivalents in Other Databases Database Equivalent Oracle INITCAP PostgreSQL INITCAP text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - LENGTH Function Informix - LENGTH Syntax LENGTH() Description LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN IBM DB2 LENGTH MySQL CHAR_LENGTH PostgreSQL LENGTH text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/lower?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - LOWER Function Informix - LOWER Syntax LOWER() Description LOWER function returns string with each letter in lowercase Equivalents in Other Databases Database Equivalent Oracle LOWER SQL Server LOWER IBM DB2 LCASE MySQL LOWER PostgreSQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/lpad?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - LPAD Function Informix - LPAD Syntax LPAD() Description LPAD function returns left-padded string Equivalents in Other Databases Database Equivalent Oracle LPAD MySQL LPAD PostgreSQL LPAD text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/octet-length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - OCTET_LENGTH Function Informix - OCTET_LENGTH Syntax OCTET_LENGTH() Description OCTET_LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN IBM DB2 LENGTH MySQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/replace?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - REPLACE Function Informix - REPLACE Syntax REPLACE() Description REPLACE function returns string with the replaced occurrences of the specified string Equivalents in Other Databases Database Equivalent Oracle REPLACE SQL Server text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/rpad?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - RPAD Function Informix - RPAD Syntax RPAD() Description RPAD function returns right-padded string Equivalents in Other Databases Database Equivalent Oracle RPAD MySQL RPAD PostgreSQL RPAD text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/substr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - SUBSTR Function Informix - SUBSTR Syntax SUBSTR() Description SUBSTR function returns extract from string beginning at character position specified Equivalents in Other Databases Database Equivalent Oracle SUBSTR SQL Server text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/trim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - TRIM Function Informix - TRIM Syntax TRIM() Description TRIM function returns string with removed spaces from the left and/or from the right end Equivalents in Other Databases Database Equivalent Oracle TRIM IBM DB2 STRIP MySQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions/string-functions/upper?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - UPPER Function Informix - UPPER Syntax UPPER() Description UPPER function returns string with each letter in uppercase Equivalents in Other Databases Database Equivalent Oracle UPPER SQL Server UPPER IBM DB2 UCASE MySQL UPPER PostgreSQL