Month: September 2005

Welcome back!  This post is a followup to the post about string functions.  The difference is this time, we’re discussing functions that manipulate dates. GETDATE The most often used function I can think of, with the possible exception of COUNT(*) is GETDATE().  When called this gives you the current datestamp from the server.  This gives…

In a previous post I introduced you to calculated fields, and mentioned there were many other functions you could use to compute values or columns.  It’s time to introduce you to the eight most used functions when it comes to manipulating strings in SQL LEFT and RIGHT If you ever need the first 3 or…

When working with SQL you will inevitably be asked to return data from your database in a way it’s not stored.  You’ll be asked to return city, state and zip as a single string, yet they are stored separately.  You’ll be asked to return grand totals, but you only have line item totals.  You’ll be…