Sql Server - Replace only the first characters in a string [duplicate]

Sql Server - Replace only the first characters in a string [duplicate]

References

Reference NO 1

http://stackoverflow.com/questions/15203526/sql-server-replace-only-the-first-characters-in-a-string

Reference NO 2

http://stackoverflow.com/questions/5794183/removing-repeated-duplicated-characters

Reference NO 3

http://msdn.microsoft.com/en-us/library/windows/desktop/ms710249(v=vs.85).aspx

Reference NO 4

http://technet.microsoft.com/en-us/library/ms177532.aspx

Reference NO 5

http://www.codeproject.com/Articles/579523/Character-String-Data-Types-and-Functions-SQL-Serv

Reference NO 6

http://dba.stackexchange.com/questions/22553/how-to-remove-leading-characters-in-sql

Reference NO 7

http://www.bigresource.com/MS_SQL--Replace-a-string-in-an-NTEXT-field-in-sql-server--LaQAu7eR.html

Reference NO 8

#EANF#