In SQl 2000 I am trying to combine 3 fileds all type float, in a view i.e.( dbo.dbo_charges.charge_id + dbo.dbo_charges.user_id + dbo.dbo_charges.task_id AS new_id ) this adds these values together, I want to concatenate these together in one field (test_id)