Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

Using custom scalar functions in a WHERE clause

Using custom scalar functions in a WHERE clause

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 9.0
    • Documentation

Your IP can use custom scalar functions that are specified in a WHERE clause. For example, the following query specifies a scalar function named NEAR:

SELECT \* FROM curvalue WHERE name = NEAR('tom', 'jones');

The OpenAccess SDK SQL engine allows the IP to obtain information about the custom scalar conditions and evaluate them, returning each set of custom conditions as a list of OR predicates. Your IP must complete the following procedure to evaluate and use custom scalar functions.

Note: This feature is not supported for .NET.

TitleResults for “How to create a CRG?”Also Available inAlert