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

[luca90]

My sql:

 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 & "'"

[Arnoutdv]

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

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

[Zvoni]

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*