SQL doubt Urgent !!!!

From: Jeferson <jeff_es_at_bol.com.br>
Date: 30 Aug 2001 12:09:52 -0700
Message-ID: <4f558fba.0108301109.291e0a3d_at_posting.google.com>

[Quoted] [Quoted] How to use the parameter Decode in SQL

This is what I want.

Old value       New value
A                5
B                6
R                10
T                1

if I write a single SQL

  Select Decode(position,'A',5) from table ;

works fine, but how to do all the above table ?

Jeferson

Any Ideas would be great ! Received on Thu Aug 30 2001 - 21:09:52 CEST