Like this... (self supporting test includes function creation, test data creation, and demo of how to use the function).

--=========================================================

--      Create the function to do the concatenization

--=========================================================

--===== If the...

Actually, this is the 4th identical post  If you're not happy with an answer, please say so within the same thread instead of posting...

Please, please, please buy a book if you want good copy.  Poor grammar and typos missed by the spellchecker have nothing to do with reducing the utility of useful articles. ...

Here's a slightly different take...

Anything that has a StartTime with no matching StopTime is not reported.

Anything that is still stopped, has a stopped duration up to the current time.

It's about...

Gabor,

I know you only have read access but can you convince the DBA to install a function for you because that's the best way to lick this problem...

Cimbom,

The other posters and you are correct... pure crap on the part of the designers of the system.    Unfortunately, you sometimes have to...

Wasn't an attack on your post Julian (I shouldn't have made things so bold, "sounds" like I'm yelling ).  Nope... I was just...

Dinakar,

Kenneth's suggestion is an excellent one but, if the Comments column is VARCHAR or NVARCHAR, you don't need to create the UDF... just create the view with a small modification.... should...

No need to enter the dark and slow realm of coversions to characters...

DECLARE @vChar VARCHAR(20)

    SET @vChar = '1458.00'

 SELECT CAST(CAST(@vChar AS MONEY) AS INT)

Yep... but won't work here... the original poster said the date formats where in a mmddyy format... here's what BOL says about the "Unseparated String Format".... I've highlighted the important...

Tammy, 

Peter's solution, as usual, is spot on. His ingenious crosstabs return the sequence of numbers of 0 through 15 in less than a heartbeat and then he applies 0-11...

I just can't bring myself to use a correlated subquery...

No need for a function if you want to permanently correct the data...

 UPDATE yourtable

    SET phonenumbercol = REPLACE(

                         REPLACE(

                         REPLACE(

                         REPLACE(

                         REPLACE(

                         phonenumbercol

                         ,',','')

                         ,'-','')

                         ,'.','')

                         ,'(','')

                         ,')','')

Are you suggesting that RAC is better than Reporting Services (which is free, by the way)?

Don't ya just love Microsoft?  Fixes for their fixes!!  Thanks for the tip, Daniel and welcome to SQLServerCentral.com.