---
title: "What is the use of VALUE function?"  
description: "What is the use of VALUE function?"  
author: "Anonymous User"  
published: 2011-03-28  
updated: 2020-09-21  
canonical: https://www.mindstick.com/interview/647/what-is-the-use-of-value-function  
category: "db2"  
tags: ["db2"]  
reading_time: 1 minute  

---

# What is the use of VALUE function?

1. Avoid -ve SQLCODEs by handling nulls and zeroes in computations \
2. Substitute a numeric value for any nulls used in computation

## Answers

### Answer by Anonymous User

1. Avoid -ve SQLCODEs by handling nulls and zeroes in computations \
2. Substitute a numeric value for any nulls used in computation


---

Original Source: https://www.mindstick.com/interview/647/what-is-the-use-of-value-function

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.