Finding records ...

[HadiRezaee]

Hi all,
I wanna find all records that the name field is "Ali" or like "Ali" ... for example "AliReza" or "alireza" !!!
How can i do that ?
Can i use of Find function or i must use of SQL string ???
I'm using of DAO ...

 

[Cagliostro]

what does it have to do with C++? Learn SQL.
There is something like
select * from YourTable where YourColumn like '%Ali%' John Fill

ivfmd@mail.md

 

[HadiRezaee]

Hi again,
Can you tell me, where i must write this SQL string ?
I must write it in CDaoRecordset::Open Function ?

 

[HadiRezaee]

Hi john,
LIKE don't work !!!
str1 = select * from YourTable where YourColumn = 'Ali'
str2 = select * from YourTable where YourColumn like '%Ali%'


str1 will work ...
But str2 won't work ...

 

[Cagliostro]

it is driver specific. In SQL Server and in Access it sure works. John Fill

ivfmd@mail.md