Loading

Remove Spaces in SQL SERVER 2005

Kamlesh Nikam

15y2.5k.NET

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Shankey15y ago
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
0