grouping values

[#1]

Hi I got a field (A) with values going from 1 to 9 (maybe with new data will go over 10) and i need to group them into 3 categories of a new field (B):

If A=1 then B='1'

If A=2 then B='2'

If A>=3 then B='3+'

could you help me in writing the right script to build up the new field?

Thanks in advance

[SunilChauhan]

use below code

If (A=1, B='1',

If (A=2 , B='2',

If (A>=3 , B='3+')))

hope this helps

[CELAMBARASAN]

Hi,

     Load

               A,

               If(A=1,'1',If(A=2,'2',if(A>=3,'3+'))) AS B

     From

               Table;

May be your need is this..

Celambarasan