• Steve,

    Good solution. I agree partially with Ramesh comments, If data grows there will be performence hit but we could create index on view.

    How about putting same logic in user defined function passing parameters to filter out the data?.