You should be able to do this with a custom Scalar-valued Function.
@hkeric.wci did a write up on these a while ago. [ Good or Bad ] BAQ - SQL Procedure / Function Helpers by Martin Horton
You should be able to do this with a custom Scalar-valued Function.
@hkeric.wci did a write up on these a while ago. [ Good or Bad ] BAQ - SQL Procedure / Function Helpers by Martin Horton