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" + "%"
... 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
--sb--