• Fantastic advise folks! 😀

    Thanks a million. Definately have enough to REALLY do dome damage! :w00t:

    Noise words are causing some minor issues. Seems some people are searching for IT (Information Technology) and it's getting ignored as "it"!!! Nifty! :hehe:

    Also getting some weird results on fields containing XML data. it's correctly returning the searched values, but the XML markup (which should remain invisible to users) sometimes appears after a FTS! Super-Nifty!! :hehe::w00t::hehe:

    I've already streamlined the SP to remove all joins. I'm now loading "related" data as an array and attaching what's needed in the code instead of in SQL

    Thanks again for the resource links everyone. Great help!!

    ...the man in black fled across the desert...and the gunslinger followed...