Delphi sql: dealing with space character in field name

146 Views Asked by At

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.

0

There are 0 best solutions below