Question : Is there a SQL Server implementation of the Longest Common Substring problem? A solution that checks with all […]
Tag: substring
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 […]
SQL join on an edited field
Question : I’m trying to join Table1 and Table2 on the Url fields. However all the Urls in Table2 end […]
Delete everything after 3 character
Question : Anybody knows how to delete everything after third ‘#’ ? I tried it like this but it’s not […]