thanks so much....

I am going to try this and I believe it will work. Thanks again!

Hey thanks so much everyone! I tried using the update function in the SQL statement rather than the one i used and it works just fine!

haha...

and SQL gutter...i know...

hey...thanks

will go and try it out!

no display....just an error page

eat when you can and not when you cannot.

Thank you so much.....this codes helped alot.

eat when you can and not when you cannot.

hey thanks Antares686

that worked well. thanks so much guys

eat when you can and not when you cannot.

hey there,

I tried your method, but it doesn't seem to work.

SUM(d.length)/1000 AS LENGTH

should I be doing this?

convert(decimal(10,2)sum(d.length)/1000)) as length?

while I am at it, have to i have multiple...

thanks sqlBill.

\I have finally figure it out! thanks yeah!

eat when you can and not when you cannot.

thanks, I will try that. is it applicable if I am using it ODBC??

SQLbill...rajesh kinda got my idea already but is this applicable?? or do I need to modify. Am...