>

>	QUOTENAME (cast(DOB as varchar(254)),'"') AS DOB,
>

>
>This is the result of running the SQL:
>

>"Nov 14 1965 12:00AM"
>

>
>I need it like this:
>

>"19651114"
>

Take a look in CONVERT function in BOL

DECLARE @test DateTime
SET @TEst = GETDATE()

SELECT CONVERT(varchar(8),@Test,112)