Your query will return only records that have text "ANTONIO" at the very end of the c_descri field. The record that have spaces after "ANTONIO" will not be included. Depending on your requirements you can change it to

lcChvPro="%"+"ANTONIO" + "%"
* OR
... TRIM(c_descri) LIKE ...

>Hi all,
>
>Why this only return one row, when i have more than 30...
>

>[Form]
>lcTable='CLIENTES'
>lcChvPro="%"+"ANTONIO"
>
>[COM]
>.Open("SELECT * FROM &lcTable WHERE c_descri LIKE '"+lcChvPro+"' ", This.lcConnection)
>

>
>Thank's
>
>João Batista