Given the information posted in this thread, why don't you let me know what your design would look like.

Thanks faizjmc for jolting my brain back into place... If not for the Friday afternoon haze impeding my thoughts, I'd probably have seen that solution earlier .

tom

This SQL being used to support a development process, not a production database... The process is essentially priming a database with records to be used by a suite of...

Thanks. That is the direction I was heading... good to have a little positive validation... tom

I think I can run with that!  Thanks.

Tom

Yes, we want to search for specific records and a range of records.  It sounds like some information would need to be revealed in the column of a table, then...

Went to lunch... fresh perspective...  determined a small design change would allow me to use a function used as the value expression.

Thanks for your response!

Tom

Ah... I see.   

TOL... The SSN column could be clear-text (varchar) or cipher-text (varbinary)... So, if I can figure out how to determine the datatype of the SSN column, I think I can refactor the...