Prueba con esto:
Código SQL
[-]
SELECT (producto) as art, (codigo) as C, (grupo) as g art FROM artic WHERE art = 'correa'
Esto en Delphi sería:
Código Delphi
[-]
ADOQuery1.SQL.Add('SELECT (producto) as art, (codigo) as C, (grupo) as g art FROM artic WHERE art = ''correa''');
Saludos...