Hi Stephen

I am not sure about cast() but convert() has a parameter to define how to format the date.

>I am updating a SQL server table and one of the fields I am updating is a character field which is a combination of a persons First name, middle initial, Last name, & Dob In the code, my syntax is
>field={firstname}+{middlename}+{lastname}+cast(dob as varchar(12))
>which works fine but after I look at the field the date is stored as
>January 13th 1987 instead on 1/13/1987, are there any functions or commands
>that will help me get the date stored into this field in the desired fashion ?
>
>Thanks For Your Help !
>Stephen J. Hunt