Tom Shaw <[EMAIL PROTECTED]> wrote: > UPDATE av_summary SET rank=((det*100.0)/(tot)); only sets the > first row correctly then all the others have bogus data in rank
That seems wrong. Can you post a sample database that demonstrates this behavior? > [I]s there a "cast" operator in the SQL.... > CAST(<expr> AS <type>) Example: UPDATE av_summary SET rank=CAST(det AS real)/total; -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
