Question : This is a part of my previous question. I have the below logic to split a string value […]
Tag: substring
Mass update all cells in a column with a substring of it’s original value
Question : I need to trim the last seven characters off of all the cells in a column. This query […]
Is there a SQL Server implementation of the Longest Common Substring problem?
Question : Is there a SQL Server implementation of the Longest Common Substring problem? A solution that checks with all […]
Is there a SQL Server implementation of the Longest Common Substring problem?
Question : Is there a SQL Server implementation of the Longest Common Substring problem? A solution that checks with all […]
Timestamp and substring with regular expression
Question : I am using postgresql and I have the following table Table “public.test” Column | Type | Modifiers ——–+————————–+———– […]
Is there a more concise way in Postgres to extract a portion of a string?
Question : I’m using Postgres 9.5. I have a table with a column that records URLs. Sometimes the URL has […]
How to simplify repeating variables in where clause for multiple columns SQL Server
Question : I know there has to be a better way to evaluate a set of repeating variables against multiple […]
Changes to estimates on predicates that contain SUBSTRING() in SQL Server 2016?
Question : Is there any documentation or research about changes in SQL Server 2016 to how cardinality is estimated for […]
Remove substring from one column and put it on other column
Question : I have a table like this: CREATE TABLE `mytable` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `column1` varchar(255) […]
SQL Split Row Data Separated by Spaces
Question : I am looking for a query to find nth value in a list. The separator is anything greater […]