Hello all this is my first post.
I am trying to strip some unwanted text from a column containing department names.

This first query strips all characters after the colon in the name:
Code:
SELECT
CASE WHEN CHARINDEX(':', DB.Table.DEPT)>0 
THEN
LEFT(DB.Table.DEPT, CHARINDEX(':', DB.Table.DEPT)-1) 
ELSE 
DB.Table.DEPT
END
FROM
DB.Table
The second query...