Month: January 2022

One of the many things that you’ll need to do when working with strings is to compare them. In a perfect world – and we all know that we don’t live in one of those – we would just have to do the simplest of comparison tools – check if they’re equal. Checking if equal…… Continue reading Analogous Strings and Validation Thereof

When we start playing with strings, one of the first functions we work with is the “LIKE” operator. It’s fairly easy to grasp and easy to remember how to deal with. Thus why we’re going to go over it today because there are various possibilities with it. The first, and arguably, what you do most…… Continue reading Getting Strings to Work Like You Think They Would

Last time, we learned about CHARINDEX and all of the fun that it can do to make dealing with strings within strings a bit easier. This time, I want to talk about another function that does kind of the same thing but slightly differently. The function I’m talking about is PATINDEX. When you think about…… Continue reading Looking for Strings A Different Way

Continuing on with our series from last time – see here if you somehow missed it – let’s have some more fun with the different functions we can use with strings. This time, let’s focus on looking for different items we can use to find a string within a string. One of my favorite functions…… Continue reading Matching Strings within One Big String