I have a column that has values formatted like a,b,c,d. Is there a way to count the number of commas in that value in T-SQL?

Standard STRING_SPLIT does not allow to take last value. The trick is to reverse the string (REVERSE) before splitting with STRING_SPLIT, get the first value from the end (TOP 1 …

Apr 22, 2012 · After specifying the field in the substring function, the second argument is the starting location of what you will extract. That is, where the ';' is + 1 (fourth position - the c), …

Feb 19, 2016 · I got the following entries in my database: E01234-1-1 E01234444-1-800000000 I want to trim the entry so I get: E01234-1 E01234444-1 So basically, I want everything before …

Jun 13, 2012 · I got the following entry in my database: images/test.jpg I want to trim the entry so I get: test So basically, I want everything after / and before . How can I solve it?

Apr 27, 2009 · I have a SQL column with a length of 6. Now want to take only the first char of that column. Is there any string function in SQL to do this?

Jan 12, 2013 · SELECT * FROM MyTable WHERE CHARINDEX('word1', Column1) > 0 AND CHARINDEX('word2', Column1) > 0 AND CHARINDEX('word3', Column1) > 0 Also, please …

Jul 10, 2010 · RIGHT is only supported by SQL Server and MySQL. See my answer - there's no silver bullet for consistent substring function name & syntax across databases.

i have large string in SQL Server. I want to truncate that string to 10 or 15 character Original string this is test string. this is test string. this is test string. this is test string. Desired

How to Select a substring in Oracle SQL up to a specific character? Asked 15 years, 1 month ago Modified 4 years, 8 months ago Viewed 732k times