How to change a smalldatetime to a string?

[eo]

I have a smalldate time (e.g. 2008-02-18 00:00:00.000) and want to create a string (e.g. 20080218), but whenever I use a substring for this, it wants to create a date such as Feb 18, 2008??

EO
Hertfordshire, England

 

[r937]

use the CONVERT function

r937.com | rudy.ca

 

[bborissov]

SELECT CONVERT(varchar(8), GETDATE(), 112)

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP