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 |
danasegarane76
Posting Yak Master
242 Posts |
Posted - 2006-08-28 : 07:59:08
|
Hi team, I want to select a particular row where any fields name contains the value as 1.How can I.I am using vb as Front End and SQL server as back end. |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-08-28 : 08:08:06
|
Somthing like this Select * from TableName Where Field1 = 1 or Field2= 1 or... Chirag |
|
|
danasegarane76
Posting Yak Master
242 Posts |
Posted - 2006-08-28 : 08:12:08
|
Dear chiragkhabaria, Thanks for your reply.The table has more that 25 columns.So i need some general Module.Any field can have a value as 1.But I need to select the value of any of the fieldss. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-28 : 08:14:42
|
Like this?SELECT Field1 fFROM TableNameWHERE Field1 = 1UNIONSELECT Field2 fFROM TableNameWHERE Field2 = 1UNIONSELECT Field3 fFROM TableNameWHERE Field3 = 1... Peter LarssonHelsingborg, Sweden |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|