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 |
|
acdacd
Yak Posting Veteran
63 Posts |
 Posted - 2005-08-23 : 10:15:03
|
| Dear all,In search qeery, i use where SearchItem is like '%is%'All the follow three item will give out in result B This A B is Cthisbook C BIf i only want the second one(B is C), which the keyword must be single one, i mean not with other word, then how to do it? Also, i test serveral web site about, it seems that they use '%is%' approach. Is it common approach in web site search function?be a hardworking people!! |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-23 : 10:21:46
|
| like '% is %'MadhivananFailing to plan is Planning to fail |
 |
|
|
acdacd
Yak Posting Veteran
63 Posts |
Posted - 2005-08-23 : 10:32:35
|
| so simple!why i can think about it?be a hardworking people!! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-23 : 10:38:11
|
>>why i can think about it?Did you want to say "Why cannt I think about it?"  MadhivananFailing to plan is Planning to fail |
|
|
|
acdacd
Yak Posting Veteran
63 Posts |
Posted - 2005-08-23 : 12:01:35
|
| yes, typing mistakebe a hardworking people!! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-24 : 01:32:10
|
| Well. After you become strong in queries, you can think about that MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
search query