SELECT  RTRIM(LTRIM(CASE WHEN CHARINDEX(')',Field) > 0 THEN STUFF(yourfield,1,CHARINDEX(')',Field),'') ELSE Field END))
FROM Table

quote:

---

Originally posted by visakh16

this?

SELECT  RTRIM(LTRIM(CASE WHEN CHARINDEX(')',Field) > 0 THEN STUFF(yourfield,1,CHARINDEX(')',Field),'') ELSE Field END))
FROM Table

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---