Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ultimate_senthil
Starting Member
13 Posts |
 Posted - 2010-07-06 : 01:59:25
|
| Hi,This is related to the keyword searching.consider company A has keyword 'hospital' and company B has keyword 'care'. When I search keyword 'hospital','hospitals' company A is displayed. if i search keyword 'Care' company B is displayed. Now i am searching a keyword 'Hospital and care' both companies A and B is displayed. it was achieved by spliting up by space and append with or condition. Now i need get the same result for the keyword 'hospitalcare'. it shows of zero result. as it is not matched in the like condition 'hospitalcare%' '%hospitalcare%' ,'%hospitalcare'. How to get the results when combining two keywords.RegardsSenthilkumar.ksenthilkumar |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-06 : 08:43:49
|
Frankly, i don't understand what do you need.declare @string varchar(50)set @string = 'hospital care'select @string ,replace(@string, ' ','') |
 |
|
|
|
|
|
Keyword searching.