Brian Dunning's FileMaker Custom Functions

Null

Returns a standard Null string

  Average rating: 4.6 (25 votes) Log in to vote

Derek Bastille   Derek Bastille
University of Alaska Fairbanks

Share on Facebook Share on Twitter

  Sample input:
Null
  Sample output:
NULL

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This is the companion function for isNull(). Together these functions can be used to look for missing values, parameters, etc. I frequently set the return of scripts to Null in cases of errors.
This function just returns the string "NULL". This makes it easy to test for. For example If( test1; "foo"; Null)

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.