1
Reply

Remove Spaces in SQL SERVER 2005

Kamlesh Nikam

Kamlesh Nikam

Feb 4 2011 4:13 AM
1.9k
Click here 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

Answers (1)