A long time ago, we learned the true values of boolean fields. But sometimes, {true, false, file_not_found} isn’t enough. Sometimes, you need more truthiness.

Wayne supports an application that uses its own custom macro-language to define how to generate Word documents. It’s database driven, and many of the documents depend on one notable table with 160 columns.

One column is a char(5) field called IS_EXEMPT_YN, and it supports these values:

  • YES
  • UNKN
  • TRUE
  • NULL – the string
  • (null) – the value
  • (empty string)

“NO” is not a viable option, and the application will generate incorrect documents if “NO” is used.

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!