MULTI find in sql server table

[luca90]

I have this two var:

Mydata As date
Mystring as String

I need to find if a pair of this two var are present in mytable based filed F1 (date filed) and F2 (string field)

example:

Mydata=18/06/2022
Mystring="123456"

F1 F2
19/06/2022 123456
18/06/2022 123456
21/06/2022 123456

in my case the relation is present in second row

i can use SEEK, .find, .filter....or?

note:
i use CN as ado connection

[Arnoutdv]

Do you know how to write SQL queries?
If not then start with some basic online tutorials, like w3schools

[Zvoni]

Yes, SQL is the way to go
(and this thread to the Database-Forum)