just some info for anyone else who's not a sql guru:<BR><BR>i did the following selection on a table:<BR><BR>SELECT * FROM Table WHERE myField <> 'active'<BR><BR>the values in that colum are a mix of ...
I'm trying to put together a DTS package to export data from SQL Server (2k) into a CSV file that I can in turn import into MySQL.<BR><BR>The problem I'm running into is SQL Server exports NULL values ...
Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes. You’ve created a query that calculates an invoice total by adding the order total and the ...