implementing Search Functionality

Question

hi, i have a query regarding the implementation of search functionality. my query is: How can i implement search functionality otherthan sqlquery,joins and conditional querys? thanks and regards