sql database problem

can anyone help with this problem:

i need to head a column short_town showing in upper case the 3 left most characters of towns.
what have i done wrong below?
only SHO is shown not short_town

select acc_no, upper(substr(town,1,3)) short_town from customer
where county like 'S Glam%';

ACC_NO SHO
---------- ---

    107543     CAR
    106291     PEN
    197333     CAR
    246082     BAR
    159200     LLA
    166937     CAR
    114905     BAR
    123720     CAR

thanx in advance

mark Received on Sun Mar 19 2000 - 15:33:33 CST