remove line break and new line and tag in sql
Replace(Replace(Replace(@str,CHAR(10),''),CHAR(13),''), CHAR(9), '')