Thanks for the input.  I am trying to create a stored procedure to restore a database under a new name using the last backup.  I need to access that information from a SELECT statement within a stored procedure

Steve