restore using wildcard

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JT (anonymous_at_discussions.microsoft.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 09:12:48 -0800

i have a scheduled backup that occurs on a nightly basis.
the backup file is given a name with a date stamp - so
that each day the name is unique.

im wondering if it is possible to use a wildcard character
when specifying what file to restore

for example:

restore database spp_temp
from disk = 'c:\DevBkup\DevBkup03032004.bak'

but this won't work:
restore database spp_temp
from disk = 'c:\DevBkup\DevBkup*.bak'

any suggestions would be greatly appreciated

thanks

jt