https://wiki.ispirer.com/ 2026-04-14T07:31:27+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/db2/functions/string-functions/ascii?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - ASCII Function IBM DB2 - ASCII Syntax ASCII() Description ASCII function returns decimal representation of the first character according to ASCII code set Equivalents in Other Databases Database Equivalent Oracle ASCII SQL Server text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/character-length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - CHARACTER_LENGTH Function IBM DB2 - CHARACTER_LENGTH Syntax CHARACTER_LENGTH() Description CHARACTER_LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/chr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - CHR Function IBM DB2 - CHR Syntax CHR() Description CHR function returns character with the binary equivalent of a number specified Equivalents in Other Databases Database Equivalent Oracle CHR SQL Server CHAR text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/concat?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - CONCAT Function IBM DB2 - CONCAT Syntax CONCAT() Description CONCAT function returns concatenated string Equivalents in Other Databases Database Equivalent Oracle CONCAT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/difference?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - DIFFERENCE Function IBM DB2 - DIFFERENCE Syntax DIFFERENCE() Description DIFFERENCE function returns difference in integer representation of two strings compared by their phonetic representation Equivalents in Other Databases Database text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/insert?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - INSERT Function IBM DB2 - INSERT Syntax INSERT() Description INSERT function returns string with the replaced symbols by replacement string in the specified position Equivalents in Other Databases Database Equivalent SQL Server text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/lcase?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - LCASE Function IBM DB2 - LCASE Syntax LCASE() Description LCASE function returns string with each letter in lowercase Equivalents in Other Databases Database Equivalent Oracle LOWER SQL Server LOWER text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/left?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - LEFT Function IBM DB2 - LEFT Syntax LEFT() Description LEFT function returns specified number of characters from the left part of a specified string Equivalents in Other Databases Database Equivalent SQL Server LEFT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - LENGTH Function IBM DB2 - LENGTH Syntax LENGTH() Description LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/locate?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - LOCATE Function IBM DB2 - LOCATE Syntax LOCATE() Description LOCATE function returns position of a string in the string Equivalents in Other Databases Database Equivalent Oracle INSTR SQL Server CHARINDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/ltrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - LTRIM Function IBM DB2 - LTRIM Syntax LTRIM() Description LTRIM function returns string with removed spaces from the left end Equivalents in Other Databases Database Equivalent Oracle LTRIM SQL Server LTRIM text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/octet-length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - OCTET_LENGTH Function IBM DB2 - 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 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/position?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - POSITION Function IBM DB2 - POSITION Syntax POSITION() Description POSITION function returns position of a string in the string Equivalents in Other Databases Database Equivalent Oracle INSTR SQL Server CHARINDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/posstr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - POSSTR Function IBM DB2 - POSSTR Syntax POSSTR() Description POSSTR function returns position of a string in the string Equivalents in Other Databases Database Equivalent Oracle INSTR SQL Server CHARINDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/repeat?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - REPEAT Function IBM DB2 - REPEAT Syntax REPEAT() Description REPEAT function returns string replicated the number of times specified Equivalents in Other Databases Database Equivalent SQL Server REPLICATE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/replace?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - REPLACE Function IBM DB2 - 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/db2/functions/string-functions/right?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - RIGHT Function IBM DB2 - RIGHT Syntax RIGHT() Description RIGHT function returns specified number of characters from the right part of a specified string Equivalents in Other Databases Database Equivalent SQL Server RIGHT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/rtrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - RTRIM Function IBM DB2 - RTRIM Syntax RTRIM() Description RTRIM function returns string with removed spaces from the right end Equivalents in Other Databases Database Equivalent Oracle RTRIM SQL Server RTRIM text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/soundex?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - SOUNDEX Function IBM DB2 - SOUNDEX Syntax SOUNDEX() Description SOUNDEX function returns phonetic representation of a string Equivalents in Other Databases Database Equivalent Oracle SOUNDEX SQL Server SOUNDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/space?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - SPACE Function IBM DB2 - SPACE Syntax SPACE() Description SPACE function returns string replicated the number of times specified Equivalents in Other Databases Database Equivalent SQL Server REPLICATE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/strip?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - STRIP Function IBM DB2 - STRIP Syntax STRIP() Description STRIP function returns string with removed spaces from the left and/or from the right end Equivalents in Other Databases Database Equivalent Oracle TRIM text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/substr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - SUBSTR Function IBM DB2 - 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 SUBSTRING text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/substring?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - SUBSTRING Function IBM DB2 - SUBSTRING Syntax SUBSTRING() Description SUBSTRING 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/db2/functions/string-functions/translate?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - TRANSLATE Function IBM DB2 - TRANSLATE Syntax TRANSLATE() Description TRANSLATE function returns string with replaced occurrences of each character specified to its corresponding character specified Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/trim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - TRIM Function IBM DB2 - 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 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/string-functions/ucase?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - UCASE Function IBM DB2 - UCASE Syntax UCASE() Description UCASE function returns string with each letter in uppercase Equivalents in Other Databases Database Equivalent Oracle UPPER SQL Server UPPER