Kamlesh Nikam

Kamlesh Nikam

  • NA
  • 95
  • 93.8k

Remove Spaces in SQL SERVER 2005

Feb 4 2011 4:12 AM
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)