easy way to manipulate data for view?

  • Thread starter Thread starter Cen
  • Start date Start date
C

Cen

Hi,
say i have 3 columns in a table in my dB:
Col 1: somenumber (int)
Col 2: id (int)
Col 3: description (varchar(30))

i want to retrieve rows from the dB, bind it to a control but want to
display the data with "somenumber" processed before displayed, in this
format:
Col 1: functionX(somenumber)
Col 2: id
Col 3: description

After the user updates the data in the control, the dB is updated with the
reverse function of functionX applied to the userinput to get 'somenumber'.

How can i do this, without using things like stored procedure?

TIA.
 
Back
Top