Wayne,

You are awesome, thank you so much.  This is exactly what I was looking for.

Would you happen to have an example?  that would help out a lot!

This is all I have

SELECT

statusID,

CHARINDEX(':',status)+1 AS dOH,

CASE

   WHEN CHARINDEX(':',status)+1 = 1

 THEN LTRIM(SUBSTRING(status,CHARINDEX(':',status)+1,50))

   ELSE SUBSTRING(status,0,CHARINDEX(':',status))

END  AS status1,

CASE...