Column troubles

I've got a table which goes something like this:
id usertext1 usertext2 usertext3 label1 label2
label3
123 12 12A12345 BPU
Charge
124 08B14501 8 Charge
BPU
.....
When I want to make a select statement I know which column has "Charge", but
I don't know where "BPU" is. This can be in a different column each time.
How can I make a select statement to find out in which column the "BPU" valu
e
is. Something like: select (something) where id='123'
I want to fit it into a webpage, but I have to get the right select statemen
t
first.
I pick up the "Charge" column from the page and want to set the first two
digits from the accompanying column (e.g. label2/usertext2) in the column
where the "BPU" is.
This is probably not very clear, but it's a bit difficult to explain.
So if you need further information to help me, please ask, because I really
need some help here.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1Hi
Check out http://www.aspfaq.com/etiquette.asp?id=5006 on how to post DDL and
sample data
If you wish to select any rows that contains BPU in label1 or label2 use
something like
SELECT id,usertext1,usertext2,usertext3,label1,
label2
FROM MyTable
WHERE label1 = 'BPU' OR label2 = 'BPU'
If you want to select them in different orders
SELECT id,usertext1,usertext2,usertext3,label1,
label2
FROM MyTable
WHERE label1 = 'BPU'
UNION
SELECT id,usertext1,usertext2,usertext3,label2,
label1
FROM MyTable
WHERE label2 = 'BPU'
Therefore the column containing 'BPU' will always be the 5th column in the
result set.
John
"Rune Thandy via droptable.com" <u17273@.uwe> wrote in message
news:65efb7eb91074@.uwe...
> I've got a table which goes something like this:
>
> id usertext1 usertext2 usertext3 label1
> label2
> label3
> 123 12 12A12345 BPU
> Charge
> 124 08B14501 8 Charge
> BPU
> .....
>
> When I want to make a select statement I know which column has "Charge",
> but
> I don't know where "BPU" is. This can be in a different column each time.
> How can I make a select statement to find out in which column the "BPU"
> value
> is. Something like: select (something) where id='123'
> I want to fit it into a webpage, but I have to get the right select
> statement
> first.
> I pick up the "Charge" column from the page and want to set the first two
> digits from the accompanying column (e.g. label2/usertext2) in the column
> where the "BPU" is.
> This is probably not very clear, but it's a bit difficult to explain.
> So if you need further information to help me, please ask, because I
> really
> need some help here.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200609/1
>