Remove Spaces in SQL SERVER 2005

Question

hi.
i have created one Query for Searching the Address

SearchQuery = SearchQuery + " and (Address like '%" + txtContactSearch.Text.Trim() + "%')";

when i am storing address in one line means PuneMaharashtra then It search Perfect.

but if i store the address like (Pune Enter Here(Means On Next Line) Maharashtra) so it is not searching so please help me

Thanks
Kamlesh

Shankey · Answer

hi I tried as below and it give the result: insert into address values('PuneMaharashtra') insert into address values('Pune' + CHAR(13) + 'Maharashtra') select * from address where addresscol like '%Maharashtra%' select * from address where addresscol like '%Pune%' Are you looking for something like this..... Please reply