Ho do I deal in the sql text with fields that have a space character. For example in db biolife I have the field: Species Name both my attempts did not work:
query1.SQL.Text := 'SELECT Species Name FROM biolife';
query1.SQL.Text := 'SELECT ''Species Name'' FROM biolife';
The first one gives error, the second gives wrong result.