That's it. Thanks alot.

Gotcha Thanks Keith.

Thanks GSquared

I was heading down that way with what I found at.

http://weblogs.asp.net/ryanw/archive/2006/02/02/437242.aspx

Sorry about that, I would like it to fire before the insert/update.

so the data is in the correct format.

so instead of name+name I will insert this as name...

They are direct insert from a classic asp application.

It's being dynamically created using syntax like element and looping.

It's used mulitiple times to insert different values in different tables, so I...

That was it.

,SUM(Cast(Num_Meeting_Goal AS Decimal(18,2))/num_participants) * 100 As 'Program Participation Level2'

I was doing the division first then casting it as decimal, which did not work.

Thank you,

Keith