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 |
|
nicklibee
Starting Member
2 Posts |
 Posted - 2015-01-09 : 02:07:01
|
| Dear all,I have following tableid id1 id2 id3 id4 description1 1 0 0 0 A2 1 1 0 0 B3 1 1 1 0 C4 1 1 1 1 D6 1 2 0 0 BB 7 1 2 1 0 CC8 1 2 1 1 DD if user searches for D, i want to display A-B-C-Dif user searches for DD, i want to display A-BB-CC-DDpls help me to generate sqlthanksnicknicklibee |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-09 : 09:10:35
|
| select description where @user_search_parameter >= description |
 |
|
|
|
|
|
query