Sachin - thank you for starting things out here with this logic. I appreciate it! I am still getting compile errors (though it will make the Stored Procedure now) in that the bracketed columns are showing to be invalid. When I try to run it after compiling it, it comes back with the following error:
Msg 50000, Level 16, State 1, Procedure sp_SOS, Line 259
No records were found macthcing your criteria.
There definitely are matching records, so I once again am - stuck.