Hey Michael,
Thanks for the prompt reply.
I did check each and every search option available in the entire site before posting here, all but one are working.
Hence need to know why only this search would give me a database error and how to fix it.
Regards,
Sam