Using SBM–Processed SQL for Multi-Selection, Multi-Group, and Multi-User Fields

Multi Selection, Multi-Group, and Multi-User fields are stored as character data in your database. The IDs corresponding to the individual selection values are represented in a comma-delimited string, such as 142, 143, 145.

SQL rules indicate that the only operator allowed with Text columns is LIKE or NOT LIKE. SBM increased the flexibility of reporting on this type of field to allow the use of some comparison operators, such as =, <>. These comparison operators translate to LIKE and NOT LIKE when the SQL statement is parsed.

Related Topics

About SBM–Processed SQL

Examples of SBM–Processed SQL

Examples of Using LIKE and NOT LIKE Operators in SBM–Processed SQL

Common SQL Operators