Interesting thing about storing the DOB as a character string in mmddyyyy format, it is easy to flip it to yyyymmdd and then convert to a date:

create table dbo.names (name varchar(50), DOB varchar(8), age int,

address varchar(50), city varchar(20),

state varchar(2), zip varchar(5), phone varchar(10));

insert dbo.names values ('William Johnson', '07191940', 74,

'262 Conner Jay Rd.', 'Brevard',

'NC', '26419', '8281254483');

insert dbo.names values ('Kay Johnson', '04101942', 71,

'262 Conner Jay Rd.', 'Brevard',

'NC', '26419', '8281258459');

go

select

n.name,

n.DOB,

cast(right(n.DOB,4) + left(n.DOB,4) as date) NewDOB,

n.age,

n.address,

n.city,

n.state,

n.zip,

n.phone

from

dbo.names n;

go

drop table dbo.names;

go