https://wiki.ispirer.com/ 2026-04-07T15:10:12+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/sql-server/functions/string-functions/ascii?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - ASCII Function SQL Server - 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 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/char?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - CHAR Function SQL Server - CHAR Syntax CHAR() Description CHAR function returns character with the binary equivalent of a number specified Equivalents in Other Databases Database Equivalent Oracle CHR text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/charindex?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - CHARINDEX Function SQL Server - CHARINDEX Syntax CHARINDEX() Description CHARINDEX function returns position of a string in the string Equivalents in Other Databases Database Equivalent Oracle INSTR text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/difference?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - DIFFERENCE Function SQL Server - DIFFERENCE Syntax DIFFERENCE() Description DIFFERENCE function returns difference in integer representation of two strings compared by their phonetic representation text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/left?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - LEFT Function SQL Server - LEFT Syntax LEFT() Description LEFT function returns specified number of characters from the left part of a specified string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/len?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - LEN Function SQL Server - LEN Syntax LEN() Description LEN function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/lower?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - LOWER Function SQL Server - LOWER Syntax LOWER() Description LOWER function returns string with each letter in lowercase Equivalents in Other Databases Database Equivalent Oracle LOWER text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/ltrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - LTRIM Function SQL Server - LTRIM Syntax LTRIM() Description LTRIM function returns string with removed spaces from the left end Equivalents in Other Databases Database Equivalent Oracle LTRIM text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/nchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - NCHAR Function SQL Server - NCHAR Syntax NCHAR() Description NCHAR function returns character with the binary equivalent to number in national character set specified Equivalents in Other Databases Database Equivalent Oracle text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/patindex?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - PATINDEX Function SQL Server - PATINDEX Syntax PATINDEX() Description PATINDEX function returns position of a pattern in the string Equivalents in Other Databases Database Equivalent Oracle REGEXP_INSTR text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/quotename?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - QUOTENAME Function SQL Server - QUOTENAME Syntax QUOTENAME() Description QUOTENAME function returns validated quoted string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/replace?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - REPLACE Function SQL Server - REPLACE Syntax REPLACE() Description REPLACE function returns string with the replaced occurrences of the specified string Equivalents in Other Databases Database Equivalent Oracle REPLACE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/replicate?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - REPLICATE Function SQL Server - REPLICATE Syntax REPLICATE() Description REPLICATE function returns string replicated the number of times specified text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/reverse?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - REVERSE Function SQL Server - REVERSE Syntax REVERSE() Description REVERSE function returns string in reversed order text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/right?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - RIGHT Function SQL Server - RIGHT Syntax RIGHT() Description RIGHT function returns specified number of characters from the right part of a specified string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/rtrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - RTRIM Function SQL Server - RTRIM Syntax RTRIM() Description RTRIM function returns string with removed spaces from the right end Equivalents in Other Databases Database Equivalent Oracle RTRIM text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/soundex?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - SOUNDEX Function SQL Server - SOUNDEX Syntax SOUNDEX() Description SOUNDEX function returns phonetic representation of a string Equivalents in Other Databases Database Equivalent Oracle SOUNDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/space?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - SPACE Function SQL Server - SPACE Syntax SPACE() Description SPACE function returns string replicated the number of times specified text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/stuff?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - STUFF Function SQL Server - STUFF Syntax STUFF() Description STUFF function returns string with the replaced symbols by replacement string in the specified position text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/substring?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - SUBSTRING Function SQL Server - SUBSTRING Syntax SUBSTRING() Description SUBSTRING function returns extract from string beginning at character position specified Equivalents in Other Databases Database Equivalent Oracle text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/unicode?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - UNICODE Function SQL Server - UNICODE Syntax UNICODE() Description UNICODE function returns decimal representation of the first character according to the unicode code set text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions/string-functions/upper?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - UPPER Function SQL Server - UPPER Syntax UPPER() Description UPPER function returns string with each letter in uppercase Equivalents in Other Databases Database Equivalent Oracle UPPER