Search results
29 cze 2011 · What is the most efficient and elegant SQL query looking for a string containing the words "David", "Moses" and "Robi". Assume the table is named T and the column C.
Definition and Usage. The REPLICATE () function repeats a string a specified number of times. Syntax. REPLICATE (string, integer) Parameter Values. Technical Details. More Examples. Example. Repeat the text in CustomerName two times: SELECT REPLICATE (CustomerName, 2) FROM Customers; Try it Yourself » Previous SQL Server Functions Next .
20 sty 2019 · Use REPLACE multiple times on a single column. Using REPLACE in a statement allows us to update, or 'replace' something from a string with something else, like this: DECLARE @sample VARCHAR(15); SET @sample = 'Mister Jones'. SELECT @sample [Old], REPLACE(@sample,'Mister','Mr.') [New];
22 mar 2022 · Table of Contents. What Is the SUBSTRING () Function? How Does SUBSTRING () Work? Example 1: Substring From a String Literal. The Employees Table. Example 2: Substring From a Column. Example 3: Substring Without the Length Argument. Example 4: POSITION () and CHARINDEX () Example 5: LENGTH () + POSITION ()
6 dni temu · 3.1. In the SELECT Clause. First, we’ll take a look at an example with the Student and Exam tables, in which we’ll retrieve each student’s name and the number of exams they’ve taken: SELECT s.name, (SELECT COUNT (*) FROM Exam e WHERE e.student_id = s.id) AS exam_count FROM Student s;
26 mar 2024 · Here’s how you can accomplish this using three methods: String Functions. Recursive CTE (Common Table Expression) STRING_SPLIT Function. 1. String Functions. SUBSTRING and LOCATE: This method involves SQL string manipulation functions to extract individual items from a delimited string.
8 cze 2017 · Well, you can always use REPLACE to add a single-character delimiter to the argument before passing it in. You just need to choose a character that is unlikely/impossible to appear in the actual data.
