NANVL
SQL SQLPosted by admin on 2023-01-29 09:58:30 |
Share: Facebook | Twitter | Whatsapp | Linkedin Visits: 646
This function is utilized to deliver an optional value n1 if the inserted value n2 is NaN (not a number), and gives n2 if n2 is not a number. This function is used only for type BINARY_FLOAT. The following query is displaying its use:
Example
1 2 | SELECT bin_float, NANVL(bin_float,0)FROM my_demo_table; |
Search
Recent Blogs
- How to Restrict Multiple Instance of VBA?
- Important Shortcuts for Excel VBA
- VBA Code to Highlight Named Ranges
- VBA Code to Highlight Cells with Misspelled Words
- VBA code to Highlight all the Blank Cells Invisible Space
- VBA code to Highlight Unique Values
- VBA Code to Hide all but the Active Worksheet
- VBA Code to Unhide all Hidden Worksheets