T-SQL to Enforce Proper Case Capitalization

Capitalize the First Letter of Each Word
Capitalize the First Letter of Each Word

This handy-dandy T-SQL query will take any input string and capitalize the start of each word within the string. It will also enforce proper use of lower-case throughout the string without affecting query performance too severely. This query assumes that you are working with titles, user names, or place names where you want to make sure that the first letter of each word is capitalized. Continue reading “T-SQL to Enforce Proper Case Capitalization”

Advertisements

SSRS: Simple Code Examples of Handling Null or Blank Date Fields

If you are looking for either null or blank values for a date field in SQL Server Reporting Services (SSRS) you will find that checking for IsNothing only identifies the Null values, but ignores the blank values. So what’s the quickest and easiest way to do this? Continue reading “SSRS: Simple Code Examples of Handling Null or Blank Date Fields”

JavaScript Helper Tool to Automatically Duplicate Elements in a List and Insert Code Between Them

Duplicate Text Tool
Duplicating List items and Adding Code Between them

In this article I will do something a bit different from my usual. Typically I review programming issues or topics of interest. In this case, however, I am presenting a handy new tool that will hopefully speed up a small, but time-consuming part of anyone’s development. That is, I have put together a tool that will let you separate a list of items, and duplicate each of those items several times while injecting code of your choosing between each duplicate as well as in front and in back. Continue reading “JavaScript Helper Tool to Automatically Duplicate Elements in a List and Insert Code Between Them”