In 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
In the last SQL post, I showed you SUBSTRING, and how you could use it to locate the area code in an un-formatted phone number. The problem was the field we were working from was full of malformed numbers. Today, we’ll start on cleaning up the numbers. But first, I need to include my standard…Read More String Manipulation — REPLACE
After the last post, I worked on getting a heating system put into the addition. As of last night, that’s done. It only cost 3 grand. (that’s more than i used to make in 7 weeks) I am ever so thankful to have a job that pays me a good wage. If i was still…Read More Work, work, then some more work.