hey greg and adamm i have a ques its simple though ....

what is the use of "0 " in that when i tried to execute

right ("0"+ (dt_str,4,1252)right--------

it says invalid column 0...actually y do we use 0 over there nad what is the need of using dt_str ,4,1252 i tried without using that for a select statement it wrks

select right(datepart("yyyy",getdate()),4)

2008 is the o/p

whats the use of that n y we should use zero n y is it saying invalid column 0...plz let me know thkz in adavance...