MS SQL Server Remove (Delete

Remove or replace certain characters, spaces, enters, tabs or user-defined in fields (columns) in MS SQL Server 2000 or 2005 using different methods. Remove character(s) at beginning, end or inside by position or by referencing surrounding character(s). Remove ALPHA, numeric, alpha-numeric or non-alpha-numeric.