Thanks. I tried both of your suggestions, but no joy...

Here's the code sniplet:

my $dbh = DBI->connect( 'dbi:AnyData(RaiseError => 1):' );
$dbh->func( 'sms', 'Tab', $file, 'ad_catalog');

my $query = qq/select * from sms where "System Status" = '?'/;

my $sth = $dbh->prepare( $query );
$sth->execute( 'ACTIVE' );

return $sth->fetchall_hashref( 'System Number' );
[download]

Here's the data sniplet:

System Number\tSystem Status\tSystem Duration
10001        \tACTIVE       \t600
10002        \tINACTIVE     \t0
10003        \tACTIVE       \t900
...
[download]

When I use just select * from rms, naturally, I get all the file's data (of which I am currently filtering later in my process).

However, it's interesting that with select * from rms, I'm able to use 'System Number' as a parameter in fetchall_hashref to retrieve all the data keyed on it, especially when it contains a space in its name.