String Functions (Transact-SQL) - SQL Server | Microsoft Learn
Nov 18, 2025 · 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 (Database …
SQL Server String Functions
Search for a substring inside a string starting from a specified location and return the position of the substring. Returns the starting position of the first occurrence of a pattern in a string. Returns a string …
SQL Server Functions - W3Schools
SQL Server has many built-in functions. This reference contains string, numeric, date, conversion, and some advanced functions in SQL Server.
SQL | String functions - GeeksforGeeks
Dec 1, 2025 · SQL string functions help manipulate and format text data efficiently. They are widely used for cleaning, comparing, and extracting meaningful information from textual fields.
Manipulate Strings in SQL Server with REPLACE, TRIM, STUFF, …
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 argument indicating what …
SUBSTRING, PATINDEX and CHARINDEX string functions in SQL …
In this article, we will explore SUBSTRING, PATINDEX and CHARINDEX string functions for SQL queries. While working with the string data, we perform various calculations, analytics, search, …
T-SQL - String Functions - Online Tutorials Library
MS SQL Server String functions can be applied on string value or will return string value or numeric data. Following is the list of String functions with examples. Ascii code value will come as output for a …
SQL String Functions - Tutorial Gateway
These functions allow us to alter the individual characters in a string, compare two, search for a substring, extract substrings, and copy. You can also use these String Functions to convert them to …
SQL String Functions: A Complete Overview - LearnSQL.com
May 9, 2024 · SQL string functions manipulate string (including text and alphanumeric) values. Also known as text functions in SQL, string functions take one or more string values as an argument and …
SQL Server String Functions (Full List) - Database.Guide
May 19, 2019 · The following is a list of T-SQL string functions available in SQL Server. Click on each function or operator name to see an explanation of the function, its syntax, and examples.