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 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?

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

How to Select a substring in Oracle SQL up to a specific character? Asked 15 years ago Modified 4 years, 7 months ago Viewed 731k times

Oct 21, 2013 · SQL SELECT everything after a certain character Asked 12 years, 1 month ago Modified 1 year, 5 months ago Viewed 162k times

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?

This will only work if your using a prepared query. If you're using an actual string in there (ex. liquibase sql upgrade script) then consider INSTR mentioned below). This is because if your …

It's detailed in Pattern matching as: The substring function with three parameters, substring (string from pattern for escape-character), provides extraction of a substring that matches an SQL …

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 …

Feb 5, 2015 · select count (value) as count from table 1 join table 2 on substring (value,20,10)=substring (code,0,10) where reference='1'. this will work for 2nd query, but it is …