• Luis Cazares (8/14/2012)


    Wouldn't this be defined by the regional settings? If the settings affect the format for money, this can result problematic.

    I don't believe so. Normally I'd just test it, but I'm having a bit of a busy day.

    dwain.c (8/14/2012)


    Cadavre +1 for a very clever solution.

    Thank you. I was hoping someone would have a method that would blow it away (the performance isn't great) 🙂


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/