Daily Archives: February 23, 2017


The right() function returns the right part of a character string with the specified number of characters. It starts on the right side and returns the number of characters you specify. If you string was ‘123456789’ and you specified 3, you would get 789 returned. If you specified 4, you […]

SQL Server right() function with cast()


There is a difference between the SQL keyword UNION and UNION ALL. To show the difference we will look at some queries here. In this example, we don’t use a database. We Don’t need to. Using some constants we will first use UNION ALL and we get the results we […]

SQL Server UNION and UNION ALL