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 |
|
insanepaul
Posting Yak Master
178 Posts |
 Posted - 2009-02-03 : 06:40:47
|
| I have a select command that displays 6 columns below. The sixth column i need to use the referenced names not the ID. So in the select command I would insert another select command as shown just below the table to get their corresponding names. However, when looking at the luoption table at the bottom, I notice that there are 1 or more words separated by a pipe. How would I display this on screen? I'm thinking I should get the corresponding items anyway using the select statement below then in my C# code separate the words from the pipe then populate a combo box. Is this the way it's done?1 Title Project Name 1 TextArea 02 Descri Project State 1 TextArea 03 Owner Project Leader 1 SpecialList 09 Status RAG 1 Combo 38515 LastSave 1 Special 305(SELECT sname FROM luoption WHERE (loptionid = strToolinfo.loptionid)) as NameTable luOptionID sName0 Text Entry385 |A = Go|B = Modify|C = Wait|D = Kill305 |Product 1|Product 2|Product 3|Product 4|Product 5 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Separating words in a field