I tried it too.

select * from COUNTRY where NAME starts 'something'

The error is that:
Dynamic SQL Error
SQL error code = -206
Column unknown
SOMETHING
At line 1, column 43.

Daniele Teti wrote:

>Leonardo Nakahara de Oliveira wrote:
>
>
>>Hello all,
>>
>>I'm developing an application on .Net using the
>>FirebirdNETProvider-1.6.3-NET1.1 found on the Firebird site.
>>
>>So, i need to make a query like that:
>>
>>"select from <table> where <field> like '<something_the_user_wrote>%'"
>>
>>
>
>Try this
>
>select from <table> where <field> starts '<something_the_user_wrote>'
>
>
>bye
>
>