Thanks. Where's a good place to learn about working with dates, using datediff, etc.?

I'm still a bit confused....I've got some 200 records under the column name birthday, which is bigint yyyymmdd ...

So I'm a little confused where the name of my table...

bigint

Where would I put that fix?

i'm using this script right now.

SELECT

case when CHARINDEX(',',new_contributor) > 0 then

LEFT(new_contributor,CHARINDEX(',',new_contributor) - 1)

else

new_contributor

end as [LNAME],

case when CHARINDEX(',',new_contributor) > 0 then

RIGHT(new_contributor,LEN(new_contributor) - CHARINDEX(' ',new_contributor))

else NULL

end...