SQL Server has many built-in functions. This reference contains string, numeric, date, conversion, and some advanced functions in SQL Server.

5 days ago · When string functions are passed arguments that are not string values, the input type is implicitly converted to a text data type. For more information, see Data Type Conversion …

Nov 13, 2025 · SQL String Functions are powerful tools that allow us to manipulate, format, and extract specific parts of text data in our database. These functions are essential for tasks like …

In this article, we explored the SUBSTRING, PATINDEX, and CHARINDEX string functions for SQL queries. You can retrieve a specific text, data using a combination of these functions.

May 9, 2024 · This article presents SQL string functions you can use to manipulate textual or string values. Follow examples and get recommendations for further reading.

Nov 13, 2025 · SQL defines some string functions that use key words, rather than commas, to separate arguments. Details are in Table 9.9. PostgreSQL also provides versions of these …

To produce a string in a given character set, use the optional USING clause: If USING is given and the result string is illegal for the given character set, a warning is issued. Also, if strict SQL …

This page provides some handy SQL string functions that allow you to manipulate character strings more effectively.

Jan 15, 2025 · In this article, we are going to explore the most important SQL string functions that can help you clean and manipulate text data with ease. Let’s get started!

Mar 5, 2024 · With the release of SQL Server 2022, the team at Microsoft extended the capabilities of our beloved trimming functions. You can now pass in an optional character …