To Check NULL
Moderators: chulett, rschirm, roy
To Check NULL
How to check if a Filed is null, Is there a IsNull function?
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Hi Shree..
Use the expression given by KrazyKoolrohit.
Use the expression given by KrazyKoolrohit.
Code: Select all
Add else to it.
If IsNull(myfield) Then 0000 Else myfield
Hi Shree..
Do not feel so sorry. This site is to help you and everyone are very cool. I really see DS gurus here.Nothing to feel bad. You will get it by yourself, if not our Gurus are here.
Do not feel so sorry. This site is to help you and everyone are very cool. I really see DS gurus here.Nothing to feel bad. You will get it by yourself, if not our Gurus are here.
All the best..Shree0410 wrote:guys, I am so sorry to post simple ones like this, I have used this many times before and looks like I am getting too dependent on this site at times, just the moment I see a red on the screen, I come here and post it rather than 't h i n k' a while..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
![Idea :idea:](./images/smilies/icon_idea.gif)
There is also a Transform called NullToZero that you may prefer to use - though it only gives a single zero. You could apply a Fmt() function to pad that with leading zeroes.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.