Re: PL/SQL question

have you tried using the number function to convert price_tier to a number value? I think this will work.

Buddy Wolfe wrote:

> error. The column price tier is VARCHAR2, but the actual values are 11, 21, 31, 41, etc.
> I am assigning it to a varible v_price_tier state_tier.price_tier%TYPE.
 

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.