Before tackling the differences, let's recap the similiarities: They're all used to locate one string within another by identifying its first positon. 2. Unlike their Excel counterparts, they will all return 0 if the substring under scrutiny cannot be found To better illustrate the differences between the functions, I'll be using the 'TED Talks' dataset from … Continue reading What is the difference between….all the functions that find a substring 1st position?
Although rarely, it could happen that you end up with fully capitalized strings in SQL. Whilst there's often nothing wrong with the data quality, it's not very appealing to be showing the users of your analyses data in capital letters. Personally, I always get the feeling of being shouted at when I see fully capitalized … Continue reading How do I change the case of a string with SQL?
No, I still haven't forgotten I promised to get an example of a text string analysis that applies to SQL Server and PostgreSQL Happy SQL-ing!