Hi,
I have the following SQL code:
I would like to know if there is a way to bring back a "0" if no matches are found for all the items in the "DOBTable" table.
Please Login or Register to view this content.
Hi,
I have the following SQL code:
I would like to know if there is a way to bring back a "0" if no matches are found for all the items in the "DOBTable" table.
Please Login or Register to view this content.
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
That depends on the version of SQL you are using, for example Access uses NZ(field, value if null). MS SQL uses IsNull(field, value if null), and Oracle uses NVL(field, value if null).
Access it is
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks