sir,


I have a job segment in my site where the recruiters will search for the appropiate candidate.
The search goes like this :

academic qualification which is text(datatype) +

age(numeric ) from : dd-mm-yy
to (numeric ) from : dd-mm-yy

gender text(datatype)

keyword text(datatype)


Now when i want to search all this at once my sql commands , where i have written the between statements and the "AND" function do not reveal the appropiate results please help.

Ur Utter meditation in this regard is generously expected.

Regards

Auro.