• I would do this in a script component by using the .NET parse method.

    Doing this in a derived column would be too complicated.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP