Yes, how to convert this one function to a UDF would be great.

I appreciate the comment on the efficiency of a hundred UDFs. The 100 Base Rules will not all be run at once.

The next tier Status Rule chooses a subset of 10 to 20 of the total 100 Base Rules to run for that situation.

My apologies, realizing most SQL Server developers run thousounds or millions of records.

This is just a single record each time.

The total Database is a result set of regulatory values, less than 120 MB.

There will only be one record at a time run from the client.

Enterprise wide, this will run 1 record an average of every 10 seconds.

The Rule Engine manages complex Compliance rules across different government agencies.

The efficiency gain comes from central Rule management reducing the network boundry.

Right now, the Status Rules along wiith the Base Rules (like the example above) are being run from the client over ODBC.