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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-28 : 09:53:26
|
Sally writes "SELECT Data1
FROM Logos
WHERE ID=LEFT(odbc_parameter,4) + SELECT operator FROM Logos WHERE ID=RIGHT(odbc_parameter,1);
---------
one table called 'Logos' contains fields as shown
ID,Data1,Operator
1,apples,jcpenny
2,pears,tesco
3,peaches,coop
1000,bananas,waitrose
1001,strawberry,asda
This is in my logic how it should be. But it does not work!!!
odbc_parameter = 10013
Answer should be with my logic
strawberry coop
Help me PLEASE." |
|
|
|
|
|
selecting mulitple data from one odbc_parameter