How do I analyse a string length and punctuation with SQL?

Need a quick re-cap of some of the text functions in SQL? By using a combination of them, you can:  count the number of words in a string find if a string starts with a number find if a string contains a particular punctuation sign find if a string ends in a particular punctuation sign … Continue reading How do I analyse a string length and punctuation with SQL?

How do I find the first position of a string within a string with SQL?

Depending on the database you're using, the function will be called differently and may have different syntax. MySQL, vertica instr(full string, string to search) PosgreSQL position(string to search in full string) SQL Server charindex(string to search, full string, {starting position}) As you might have noticed, the function in SQL Server has an additional argument, allowing … Continue reading How do I find the first position of a string within a string with SQL?