Hi All, I have a table where a column (type- numeric) contains several thousands NULL-values. I want to covert all of these NULL values to "100" and values those are greater than "100", I want to convert these values to 100 too. How do I do this? It will be appreciated if someone help me out to write the query. Zia