i can get the default value of column_def using Stored procedure -

sp_columns tablename .

column_def returns the default value.

lets say 'abc' is set as default value of a nchar field.

the column_def shows (N'abc') as value.

If I set 10 as default value of an int column , the column_def shows ((10)) as value

i want to know exact default value.

are there some rules to intercept the exact value ?