Tag Archives: sql

Filtering Using CHARINDEX

Posted on October 18, 2023 by alapitsk

Most of the time when I need to query rows, I would use column name and LIKE operator. However, CHARINDEX operator can provide a quick way to check if a particular word or special character is present in the column. … Continue reading →

Posted in Interesting SQL Patterns | Tagged , , , , | Comments Off on Filtering Using CHARINDEX

Getting Data Left or Right of a Delimiter

Posted on March 23, 2022 by alapitsk

It is a very common case when one needs to remove values left or right of a delimiter.The pattern below should work for most of the common cases. Note that JSON was misinterpreting some special characters, therefore, I posted a … Continue reading →

Posted in Interesting SQL Patterns, Uncategorized | Tagged , , , , , | Comments Off on Getting Data Left or Right of a Delimiter