'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '" & Trim(Text77) & "' OR [f2] LIKE '" & Trim(Text77) & "'", db, adOpenStatic, adLockPessimistic
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '%" & Trim(Text77) & "'% OR [f2] LIKE '%" & Trim(Text77) & "';", db, adOpenStatic, adLockPessimistic
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '" & Trim(Text77) & "' OR [f2] LIKE '" & Trim(Text77) & "%';", db, adOpenStatic, adLockPessimistic
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '%" & Trim(Text77) & "'% OR [f2] LIKE '%" & Trim(Text77) & "%';", db, adOpenStatic, adLockPessimistic
'=======================================================================================================================================================
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '" & Trim(Text77) & "'", db, adOpenStatic, adLockPessimistic
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '%" & Trim(Text77) & "';", db, adOpenStatic, adLockPessimistic
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '" & Trim(Text77) & "%';", db, adOpenStatic, adLockPessimistic
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '%" & Trim(Text77) & "%';", db, adOpenStatic, adLockPessimistic
'=========================================================================================================
'If Option1.Value = True Then تطابق كامل
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '" & Trim(Text77) & "' OR [f2] LIKE '" & Trim(Text77) & "'", db, adOpenStatic, adLockPessimistic
'If Option2.Value = True Then نهاية الكلمة الحرف الاخير
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '%" & Trim(Text77) & "' OR [f2] LIKE '%" & Trim(Text77) & "';", db, adOpenStatic, adLockPessimistic
'If Option3.Value = True Then الحرف الاول بداية الكلمة
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '" & Trim(Text77) & "' OR [f2] LIKE '" & Trim(Text77) & "%';", db, adOpenStatic, adLockPessimistic
'If Option4.Value = True Then اي جزء من الكلمة
'RS.Open "SELECT * FROM [workers] WHERE [f1] LIKE '%" & Trim(Text77) & "' OR [f2] LIKE '%" & Trim(Text77) & "%';", db, adOpenStatic, adLockPessimistic