If Len(Trim('InputLink.InputCol)) = 0
Then "it is spaces or NULL"
Else "It is not spaces or NULL"
Hope that helps,
Naveen.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
There is a difference between blank and NULL. NULL is a physical character on the ASCII chart, blank is a zero length string. You can NEVER, in SQL or DS BASIC, compare ANYTHING to a NULL. You can't do math on NULL values either. That's why there's a specific function in DS BASIC and SQL to handle the NULL value.
You should consider writing either a DS Function or DS Transform to handle both cases. I like to use a function called something like EXISTS.
IF TRIM(Arg1) # "" OR NOT(ISNULL(Arg1)) Then Ans=@TRUE Else Ans=@FALSE
Now, you can just check if data "exists" using this function. It correctly handles both the blank and NULL condition.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle