Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Remove Spaces in SQL SERVER 2005
Kamlesh Nikam
Feb 4 2011 4:13 AM
1.9k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Remove Spaces in SQL SERVER 2005
Ascii value