Thankds david, I'm using MSSQL.
I'll give it a go! Cheers, Nick :> -----Original Message----- :> Nick, :> :> Are you using SQL Server? SELECT TOP 1 col FROM tbl ORDER BY :> NEWID() should :> do the trick. :> :> There are other ways for other DBMS...of course :-) :> :> David L. Penton, Microsoft MVP:> JCPenney Technical Specialist / Lead --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
