Select statement error on where clause

Hi @Gijsbert 

The error message you're encountering seems to indicate an issue with the way the filter expression is being constructed and handled by the `Select-SAPHybrisC4C` command. The error message suggests that the expression cannot be converted into ABAP select options.

One way to approach this issue is to modify the query to construct the filter differently. Instead of multiple 'not equals' conditions for `FunctionCode`, you can use an `IN` clause to filter multiple values in a more concise way.

Here's an example of how you might modify your query:

$where = "StatusCode = '2' and FunctionCode NOT IN ('Z14', 'Z95', 'Z96', 'Z97');" 
$A = Select-SAPHybrisC4C -Connection $conn -Table "ContactCollection" -Columns $Columns -Where $Where

Using the `NOT IN` clause allows you to specify multiple values for `FunctionCode` in a single line, which might help avoid the issue you're facing with the conversion into ABAP select options.

If this modification still doesn't resolve the issue, you might consider reaching out to the Tech support at https://www.cdata.com/support/submit.aspx for further assistance or alternative approaches to construct your filter condition.

Additionally, ensure that the syntax and capabilities of the querying tool align with the SQL-like syntax being used in your PowerShell script.