Hi, This could be done in several ways. Here's a script that I came up with. It uses the Products table of the AdventureWorks database. It randomly selects a record and displays the [Name] and [ProductNumber] columns: SELECT    [Name],    [ProductNumber]FROM    (        ...