Combine Fields 1

[daguas]

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)

 

[jararaca]

SELECT CONVERT(VARCHAR(10), Charge_id) + CONVERT(... AS FieldName
FROM dbo.dbo_charges

 

[daguas]

Thanks much, that worked great..