Hi ,

Not sure that the following code will help u or not. If it then u may put it into proc or can use it to update.Given below example as a '29/10/2007' (assume as a variable in this format)

select

convert(datetime,

substring('29/10/2007',charindex('/','29/10/2007')+1,2)+'/'+

left('29/10/2007',charindex('/','29/10/2007')-1)+'/'+

right('29/10/2007',charindex('/',reverse('29/10/2007'))-1)

)

thnx,

Arjuna

Orange (India)