Wednesday, April 25, 2012

Replace Square box in SQL table

In Sql Table some Column have value of Square box, if you want to remove that box please use below SQL Query:

 select REPLACE(ColumnName,char(13),'') from YourTable

 If You want to use in Where condition trim that Square box use this :

 where REPLACE(ColumnName,char(13),'')in ('ColumnValue')
-->