Hi,

I have a Integer column in a table which is basically the datekey,e.g 20101101.
If I want to get only the year and month from this column is it better to use left(datekey,6) OR datekey/100.
The Left would use implicit conversion.
Which would be faster ?

Thanks !