在新列中更新sql查询

I have a column in which i have 'goswara no. 21/1980' i need only 21 and year from date column like this col gr=21/year(date) through sql2005 query I have a column in which i have 'goswara no. 21