I’m currently putting together some notes on a series I’d like to share with all of you. This series will cover the fundamentals of Transactional SQL (T-SQL). I’m hoping that it will grow into an introduction to database development. I’ll begin with the very basics of what a database is, and what SQL is. Then…
Read More An Upcoming Series…So far I’ve shown you just a few of the many string manipulation functions available in Microsoft SQL. Today we’re adding two more of these tools to your tool belt. CAST and CONVERT. These two become useful when you’ve stored a value as one data type, and later find you need it used as another. …
Read More String Manipulation — CAST and CONVERTIn the previous SQL posts, I showed you SUBSTRING, then I showed you REPLACE. Now, with REPLACE, you had to know what characters you wanted to replace. What if you only knew what characters you wanted to keep? Well, let me introduce you to PATINDEX. This is an advanced command that is easy to learn,…
Read More String Manipulation — REPLACE, PATINDEX and Regular Expressions