We do have a Spanish NeoBook section on the forum where you can post questions in Spanish. If you post in the other English sections of the forum, please include an English translation so that other users can participate. You can use Google Translate to convert your question to English: https://translate.google.com

dbpExecSQL "datos" "SELECT DISTINCT PROVEEDOR FROM Tabla1 WHERE (PROVEEDOR IS NOT NULL);" ""

and within the syntax where I put the variable text entry button that is looking

The translation of your first post was ...

I have a column called SUPPLIERS in which I have many of the same names as several articles have the same vendor and other items that do not have providers .The question is:When consulted SUPPLIERS need to show me just the name of each and empty fields are not visible. AsiVenier3M

And there also I get:VenierVenir

3M3M

So I do not understand your latest question ... please explain in detail what you are trying to do ... and what is a text entry button ?

I think you have to give the specific field you want to be distinct. You are using * and that implies you want to choose all records in the table so if you want distinction, you need to tell it which field you want to be distinct.

DAVIS THANKS FOR ANSWER, YOU EXPLAIN THE PROBLEM.HAVE A DATABASE IN A COLUMN NO ITEMS AND OTHER COLUMN SUPPLIER.EACH ITEM HAS ITS SUPPLIER EJ:PRODUCTO - PROVEEDORPINCEL - VENIERRODILLO - VENIERSERUCHO - 3M SEARCH FOR ITEMS YOU ACHIEVE dbpQuery "datos" "Tabla1" "PRODUCTO LIKE [#34]%[value]%[#34]" WORKS OK.

BUT TO SEARCH PROVEDOOR, NOT WORK.AS SHOW ME THE SAME SUPPLIER SEVERAL TIMES. EJ: TEXT ENTRY VENI (SERIOUS THE VARIABLE [value])EN LA TABLA SALE ASI:VENIERVENIER

You got a SYNTAX ERROR because there was a missing single quote ( ' ) in my previous post ... I have fixed it ... try it again with the fixed syntax.

If you are going to be developing Applications that deploy such advanced Database access techniques, you should first take some time to learn about SQL (capabilities, commands, syntax) ... so in future, you can figure out such simple typos all by yourself.