Thanks. I figured out the CAST later but didn't know the 1.1::numeric
syntax.
-
Water overcomes the stone;
Without substance it requires no opening;
This is the benefit of taking no action.
Lao-Tse
Brian Knox
Senior Systems Engineer
I believe the standard way is
CAST(1.1 as numeric)
But the following should also work:
1.1::numeric
Stephan Szabo
[EMAIL PROTECTED]
On Tue, 15 Aug 2000, g wrote:
> I need to know how to cast types. Here's my basic problem:
> I'm trying to:
>
> update products set list_price = gsa_price * 1.1
