Parsing field value based upon derived dataset
Posted on 2008-10-23
I am attempting to CASE a column in a view based upon a select against a separate table.
The select will return a number of distinct values; this will then be used to CASE the column in the view. This column will contain space-separated values in the form '1 2 3 4 5 A C D', etc
Consequently, if the select statements returns values of 1,2,3 and any or all of these values appears in the view column, the column should be updated as 'COMPLIANT' for example.
We're no doubt looking at a UDF here but any pointers you could offer would be appreciated.