This convert() option may work best for you:

CONVERT(varchar(12), datefld, 111) -- shows as yyyy/mm/dd which is better for sorting.

>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