Hi, just in case don't use * in your SQL statement. Names in SQL statement will be loaded in upper case. Do this:
LOAD NAME as Name,
LOCATION as Location,
ADDRESS as Address;
SELECT Name, Location, Address from xxx where trndat > '12/31/2011';
If this is not the case, please state what error you are getting.