[RESOLVED] I'M using ado , dubt on like statement, is correct?

My sql:

Code:

---

VALORE = Trim(Me.TCERCA.Text)
   
    SQL = "SELECT ABI_UNICREDIT.ABI, CAB_UNICREDIT.CAB, ABI_UNICREDIT.BANCA, CAB_UNICREDIT.SPORTELLO, CAB_UNICREDIT.INDIRIZZO, CAB_UNICREDIT.COMUNE, CAB_UNICREDIT.CAP, CAB_UNICREDIT.PR, CAB_UNICREDIT.PROVINCIA, ABI_UNICREDIT.ST, ABI_UNICREDIT.STATO, CAB_UNICREDIT.AGG" & _
          " FROM CAB_UNICREDIT INNER JOIN ABI_UNICREDIT ON CAB_UNICREDIT.ABI = ABI_UNICREDIT.ABI WHERE CAB_UNICREDIT.BANCA=like *VALORE*  AND ABI_UNICREDIT.ST='" & ST & "'"

---

Check the help page:
https://learn.microsoft.com/en-us/of...oft-access-sql

Code:

---

Sub LikeX()
 
    Dim dbs As Database, rst As Recordset
 
    ' Modify this line to include the path to Northwind
    ' on your computer.
    Set dbs = OpenDatabase("Northwind.mdb")
 
    ' Return a list of employees whose names begin with
    ' the letters A through D.
    Set rst = dbs.OpenRecordset("SELECT LastName," _
        & " FirstName FROM Employees" _
        & " WHERE LastName Like '[A-D]*';")
 
    ' Populate the Recordset.
    rst.MoveLast
 
    ' Call EnumFields to print the contents of the 
    ' Recordset. Pass the Recordset object and desired
    ' field width.
    EnumFields rst, 15
   
    dbs.Close
 
End Sub

---

Code:

---

SELECT
ABI_UNICREDIT.ABI,
CAB_UNICREDIT.CAB,
ABI_UNICREDIT.BANCA,
CAB_UNICREDIT.SPORTELLO,
CAB_UNICREDIT.INDIRIZZO,
CAB_UNICREDIT.COMUNE,
CAB_UNICREDIT.CAP,
CAB_UNICREDIT.PR,
CAB_UNICREDIT.PROVINCIA,
ABI_UNICREDIT.ST,
ABI_UNICREDIT.STATO,
CAB_UNICREDIT.AGG
FROM CAB_UNICREDIT
INNER JOIN ABI_UNICREDIT ON CAB_UNICREDIT.ABI = ABI_UNICREDIT.ABI
WHERE CAB_UNICREDIT.BANCA like '*" & VALORE & "*'  AND ABI_UNICREDIT.ST='" & ST & "'"

---

No further comments.....*facepalm*