Date to 8 char in SQL

[MWHopkins@xxxxxxxxxxxxxxx]

I'm trying to get a character representation of the current date in sql. I 
can get the date in ISO format, but it has the '-' in it. What is the 
easiest way to get the current date in YYYYMMDD format?

I know that I can do something like:

substr(char(curdate(), iso),1,4) concat substr(char(curdate(), iso),6,2) 
concat substr(char(curdate(), iso),9,2)

There must be a simpler way?! Isn't there?

Matt Hopkins 
Sr. Programmer/Analyst 
Web: www.pdpgroupinc.com 
Email: MWHopkins@xxxxxxxxxxxxxxx 
Office: 410-584-0330 
Fax: 410-584-0336 
Cell: 410-258-8845