Re: Can You convert a Field ??

I am not sure whether this is what you want: create view v_temp

    as select household_num, acct_num_display, bran,

to_number(household_num)+to_number(acct_num_display)+to_number(bran) Service_id

            from your_table.
Then you can insert the value of this view to wherever you want.

Good Luck

Angelica Veron wrote in message <37794102.F10FB411_at_globalserve.net>...
>Consider the following 3 fields :
>
>HOUSEHOLD_NUM ACCT_NUM_DISPLAY BRAN
>------------- ----------------
>----
>8427400003321 0000000574724777 2827
>8427400005053 0000000017560888 2827
>8427400005323 0000000500001670 2827
>8427400006144 0000000025590888 2807
>8427400006616 5000575
>2827
>8427400007776 0000000AB0045467 2827
>8427400007776 007800146220002 2827
>8427400009756 007300062620001 2827
>8427400009756 0360756
>2827
>8427400009756 3812853
>2827
>
> These 3 fields are
>
> Name Null? Type
> ------------------------------- -------- ----
> HOUSEHOLD_NUM NOT NULL VARCHAR2(13)
> ACCT_NUM_DISPLAY NOT NULL VARCHAR2(16)
> BRANCH_NUM NOT NULL CHAR(4)
>
>
> I need to combine the total of each 3 given fields as a new field of
>type NUMBER(10), called Service_id . So service_id would be a new 4th
>field (numerical) which has the total of Household_NUM, ACCT_NUM_DISPLAY
>and BRANCH_NUM, how do I do that ??.... how do I create a new field
>called Service_id in the above table ?. Can anyone help ?? I would be
>realy grateful for any help, thank you so much for your time.
>
>
Received on Wed Jun 30 1999 - 02:47:18 CEST