All,
New to SQL Statements (Probably a really basic question) I am attempting to extract all data where the column "Drive_Status" is not equal to "Success" any help on the below statement would be much appreciated.
SELECT * FROM [Main$] WHERE (Drive_Status <> 'Success')
**Edit - The issue with the statement above is data which is either Null or tagged "Error" in the "Drive_Status" column is not being returned.
***EDIT - The database I am using is Excel Database
Thanks in advance