Different type of null

[smilingjohn]

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 

[Anil_Babu_Samineni]

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.

[smilingjohn]

@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

[marcus_sommer]

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