The following T-SQL statement shows how output a number as an ordinal number (st, nd, rd, th). For example, 3 would output 3rd. How do I use this? Replace '3'…
The following T-SQL statement shows how output the day from a date as an ordinal number (st, nd, rd, th). For example, 16 March 2019 would output 16th. How do…
I recently had a large JavaScript array - a complex polygon of latitude and longitude coordinates. The file was undesirably large (about 32 MB) which seemed to stem from the…
The following steps show how to convert a character (for example a tab or comma) with a new line using Notepad++. For this example we'll be converting The,Quick,Brown,Fox,Jumped,Over,The,Lazy,Dog to The…
The following SQL statement shows how to copy the data from one column to another. It will replace any existing values in the destination column - so be sure to…
The following T-SQL for Microsoft SQL Server shows how to convert line separated text to comma separated text. For example, if we had a table with the following data Lucky_Numbers 2 33…
If you need to create a pivot table chart on a range that includes blank rows you'll end up with a (blank) label. There are several suggested ways to remove…
The following T-SQL for Microsoft SQL Server shows how to find and replace text in a string. In this example we'll change "PO Box" to "P.O. Box". The REPLACE function will search for…