Looking for some SQL query assistance.
2 questions:
1. Is there a way to add a dummy column to a select statement. I'm querying my db and then sending to a Recordset in VBA and then copying to MSExcel. Most of my columns' data in Excel can come from the recordset but others are simply not in the database and will need to be entered manually. In order to get my columns to line up as needed, I need to have my query results return blank columns.
2. I've used the isNull function quite a bit in SQL queries, but now ran acrross the need to return Null if the value in the field is zero. Does SQL have this function?