Append a Date to the end of a table name

Is there a way to do so on the fly in SQL Server 2000? In other words, a field has the latest update date for the table and we wish to use this date as part of the table name. If so, please provide an example.
ddaveDo you really want to do this? It sounds like a receipe for disaster to me. The general idea would go something like:DECLARE @.fubar VARCHAR(500)
SELECT @.fubar = 'SELECT * INTO [foo' + Convert(CHAR(10), GetDate(), 121)
+ '] FROM foo'
EXECUTE (@.fubar)-PatP