>>

>>	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)
>

I tried this:

	QUOTENAME (CONVERT(varchar(8),DOB,112)),'"') AS DOB,

But got this error:

Msg 102, Level 15, State 1, Line 14
Incorrect syntax near ')'.

DOH! Extra parenthesis. Sorry!