Ryan,

I have never used full-text search and did not even think about it.  I set it up and tried your suggestion and it works like a charm.

Thanks for your help.

Mark

If I understand your question correctly and you have a parent table and a child table, join the two tables with an INNER JOIN.  This will retrieve only the parent...

For assignment of values to a single variable there really is no difference.  If you are assigning values to multiple variables in succession, then you can pick up some minor...