I know BaaN SQL 'Like' instruction for the the where clause works, but I can not get the 'Not Like' to work for a where clause. Does anyone know if this works in BaaN? More specifically I can not get the following to select the right data:

where tdsls961.clot not like "%A%" (16 position field)

wanting all serial numbers that do not contain an A

Thanks
Steve

Try below:

where tdsls961.clot not like ".*[aA].*"
or
where tdsls961.clot like "[^aA]*"


Reference: Wildcard characeters (http://www.baanboard.com/programmers_manual_baanerp_help_functions_expressions_runtime_expr_compile)