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?

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.

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), …

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 …

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

Jan 4, 2012 · My SQL supports the function of a substring_Index where it will return the postion of a value in a string for the n occurance. A similar User defined function could be written to …

May 14, 2012 · I have a table like this Value String 1 Cleo, Smith I want to separate the comma delimited string into two columns Value Name Surname 1 Cleo Smith I need only two fixed …

SELECT * FROM `table` WHERE `column`.contains('textABC') In PHP, the function is called substr, so maybe:

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?

IF CONTAINS(@stringVar, 'thisstring') ... I have to run one select or another, depending on whether that variable contains a string and I can't figure out how to get it to work. All the …