Please give SQL statement for develop keyword sear

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Please give SQL statement for develop keyword sear

Author

Topic

anup_phansa
Starting Member

6 Posts

Posted - 2009-09-07 : 09:52:14

I want to create a search on Address field of xyzTable

If my searching string is “A B C D”

XyzTable

ID
1, A B C D
2, A B
3, A B C
4, 1 A
6, 2 C
7, FF
8, KK

Search Result

Out put Record

1, A B C D
2, A B
3, A B C
4, 1 A
6, 2 C

I want to develop key word search like google

Regards
Anup

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-07 : 09:59:33

split the search string and compare with table column

Madhivanan

Failing to plan is Planning to fail

anup_phansa
Starting Member

6 Posts

Posted - 2009-09-07 : 10:02:24

Hi thanks for your reply

I want to display result which match max word like google

Regards
anup

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources