I have a student table that needs some clean up. My first task is to remove all the periods (.) from the middle name column. Some people have two char middle initials with two periods. Can this be done via a SSIS package (I sure it can, but not how)? I can't think of a simple update statement that would accomplish the same thing.
Any direction would be appreciated.
Isn't it easier removing the periods by running an update query
UPDATE Students SET MiddleName = Replace(MiddleName , N'.', N'')
Eralper
http://www.kodyaz.com
|||Yes, it is :-)
Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment