How do I count number of occurences of a word in the resume? for eg: if I search for word "engineer" (should check in resume field, clob) and bring back all the candidate along with number of times "engineer"occurs in the resume. database is SQL server. I tried function CONTAINSTABLE but that gives me candidiates with rank rather than the count. Any ideas??