I am working on a Job Portal

This is the scenario.

I have word Document Saved (resume of the Candidate) in one Table and another Title (Resume Header) column thats saved in another Table. Both are enabled for Full Text.

When keywords are supplied I have to check in both the Tables and return result with other criteria.

I want to do as a function as I need to format the keywords supplied before I start matching.

(e.g) Java and Dot Net --- Should search for both Java and Dot Net in the Resume or Resume Header

Java or Dot Net --- Should search either Java or Dot Net in the Resume or Resume Header

"Java" --- Should search exact match for Java in the Resume or Resume Header

"*Java*" --- Should search wild card match for Java in the Resume or Resume Header.

along with this I have other search filters as well.

Thast why wanted to do a function which return bit and invoke it in my query