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')
-->