Yahoo India Web Search

Search results

1. www.w3schools.com › sqL › sql_ref_sqlserverSQL Server Functions - W3Schools

   www.w3schools.com › sqL › sql_ref_sqlserver

   • Cached

   Learn how to use string functions in SQL Server to manipulate, format, and compare strings. See the function description, syntax, and examples for each string function.

2. www.geeksforgeeks.org › sql-string-functionsSQL | String functions - GeeksforGeeks

   www.geeksforgeeks.org › sql-string-functions

   • Cached

   Jul 24, 2024 · String functions are used to perform an operation on input string and return an output string. Following are the string functions defined in SQL: ASCII(): This function is used to find the ASCII value of a character. Syntax: SELECT ascii('t'); Output: 116; CHAR_LENGTH(): Doesn’t work for SQL Server. Use LEN() for SQL Server.

   • Video Duration: 6 min

3. learn.microsoft.com › en-us › sqlString Functions (Transact-SQL) - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Cached

   May 23, 2023 · TRANSLATE. TRIM. UNICODE. UPPER. All built-in string functions except FORMAT are deterministic. This means they return the same value any time they are called with a specific set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.

4. learnsql.com › blog › sql-string-functionsSQL String Functions: A Complete Overview - LearnSQL.com

   learnsql.com › blog › sql-string-functions

   • Cached

   May 9, 2024 · Learn how to manipulate string values in SQL with various functions, such as concatenation, comparison, trimming, and more. See definitions, examples, and database-specific differences for each function.

5. www.tutorialspoint.com › sql › sql-string-functionsSQL - String Functions - Online Tutorials Library

   www.tutorialspoint.com › sql › sql-string-functions

   • Cached

   Learn how to use SQL string functions for string manipulation. The web page lists and describes 31 common SQL string functions with examples and syntax.

   Sr.no.	Function & Description
   1	ASCII () Returns numeric value of ...
   2	CHAR () Returns the character for each ...
   3	CHARINDEX () Returns the position of a ...
   4	CONCAT_WS () Returns concatenate with ...

   See full list on tutorialspoint.com

6. www.sqltutorial.net › string-functionsSQL String Functions

   www.sqltutorial.net › string-functions

   • Cached

   Learn how to use SQL string functions to manipulate character data in a database. See examples of CONCAT, CONCAT_WS, SUBSTRING, LEN, REPLACE, UPPER, LOWER and TRIM functions.

7. People also ask

   What are SQL string functions?

   • SQL string functions are used primarily for string manipulation. The following table details the important string functions − Returns the position of a substring within the given string. returns an integer value measuring the difference between the SOUNDEX () values of two different expressions (strings). Returns a text with escaped characters.

   SQL - String Functions - Online Tutorials Library

   www.tutorialspoint.com/sql/sql-string-functions.htm

   See all results for this question

   What is a substring function in SQL?

   • The SQL substring function in 5 examples. This function takes three strings and returns the first string where the values indicated by the second string are replaced by the values indicated by the third string. This example takes a given string value and replaces H with h and o with e.

   SQL String Functions: A Complete Overview | LearnSQL.com

   learnsql.com/blog/sql-string-functions/

   See all results for this question

   What are the functions used in SQL Server?

   • INSERT (): This function is used to insert the data into a database. INSTR (): This function is used to find the occurrence of an alphabet. LCASE (): This function is used to convert the given string into lower case. LEFT (): This function is used to SELECT a sub string from the left of given size or characters.

   SQL | String functions - GeeksforGeeks

   www.geeksforgeeks.org/sql-string-functions/

   See all results for this question

   How to return a string in SQL Server?

   • It returns a string that contains as many repetitions of the first string as indicated by the integer. Note that SQL Server uses REPLICATE () instead of REPEAT (). This function takes three strings and returns the first string where the value indicated by the second string is replaced by the third string.

   SQL String Functions: A Complete Overview | LearnSQL.com

   learnsql.com/blog/sql-string-functions/

   See all results for this question

8. www.sqlservertutorial.net › sql-server-stringSQL Server String Functions

   www.sqlservertutorial.net › sql-server-string

   • Cached

   The following SQL Server string functions process on an input string and return a string or numeric value: This tutorial provides with many useful SQL Server String functions that allow you to manipulate character string effectively.