Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have different type of nu in my data whihc i am not able to handle properly one or the other keep missing .
In my data I have empty cell some is described as null and some are described within bracket (null) i dont know how do i handle this .
I treid cinverting in the script like belo
If (isnull(ID),'null') as ID
but this is missing (null)
Can please someone help me wiht this ?
Thanks in Advance
Before raise concern please read blogs from existing via google. anyway, you can try many ways only thing whether you have real null values or not?
If (isnull(ID),'null') as ID
If (Len(ID)=0,'null') as ID etc.
@Anil_Babu_Samineni sure will search for existing blog for future concerns .
I am confused when u say "Check wheather null values do exist " what exactly do you you mean by this ?
Thanks
NULL is a special construct within many databases / programming tools and does mostly not include missing/empty values. Therefore worked isnull() only by real null(). In many cases is no differencing between the various kinds of NULL necessary / needed and therefore you could usually apply a simple check on the length like:
len(trim(FIELD))
- Marcus