Code Nuggets: Getting two SQL column values in a single column

Well this type of thing doesn’t come up very frequently (at least to me) and if you’re like me working on multiple databases it gets very frustrating when it does come up. Since I don’t use it very frequently, I tend to forget how to do it properly in the database system I am using at the time.

So it goes something like this: Suppose you have a simple SQL table called Users. Now this table has three columns, id (int), firstName (varchar) and lastName (varchar)…

Continue Reading >>