At 17:09 Friday, 15.10.2004 -0600, Rick Roen wrote:

>I'm trying to write a stored procedure to return a conversion from "x" into
>pounds to be eventually used in converting amounts in a Select.
>
>Can anyone help?

Hi Rick,

I think the CASE syntax is only valid in SELECT statements.
In stored procs you have to use multiple IF .. THEN .. ELSE
statements.

HTH,
markus