Hi,

> how can i generate random number in stored proc?? i use linux server

1.5...

Via an "User Defined Function".

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com