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 replace a string in SQL and make sure it has no extra spaces?

It was pretty cool that the substring() function had the exact same syntax in all SQL Server, MySQL and PostgreSQL Are there more functions like that?  Check out the ones below! replace() = replaces one part of a string with another ltrim() = removes leading spaces from a string rtrim() = removes trailing spaces from a string have … Continue reading How do I replace a string in SQL and make sure it has no extra spaces?

How do I determine the length of a string with SQL?

It's quite simple if you're using MySQL or PostgreSQL - the function you need in both is simply - length() There are a couple of points you'd better keep in mind if you're using SQL Server, however. 1. The function in that environment is called len() 2. Unlike length in the other two database systems, … Continue reading How do I determine the length of a string 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?

How do I get part of a string with SQL? (part 2)

Remember when we previously talked about extracting part of a string with SQL? As SQL Server and PostgreSQL would not support a "mid" function, getting a string that was placed in the middle of another could be a bit tricky.... We then solved it by applying a double right() and left() functions. There is, however, another … Continue reading How do I get part of a string with SQL? (part 2)

How do I get a part of a string with SQL? (part 1)

Remember these text functions in Excel? left (string, no of chars) retrieves specified number of characters from the left of the string mid (string, beginning, end) retrieves specified number of characters from the middle of the string right (string, no of chars) retrieves specified number of characters from the right of the string You can … Continue reading How do I get a part of a string with SQL? (part 1)