Thanks for enlightening me on the use of reverse and substring. Is a flexible way of manipulating string formats into numbers. cheers

Hello All,

My query is little different, I need to check the default value on the column using the System tables. How do i do that ??

I gotta know all...