Problem with Wildcard in whereclause. How to say where '%|%' ?

Hi Guys from Metz in France.

I would like to find the line with "|" with this whereclause. I guess the syntax is incorrect but how to fix this?

Tx in advance for your help. 

Dim f As ISqlFormatter = Connection.SqlFormatter

Value = f.AndRelation( f.Comparison("CCC_Mail","%|%", ValType.String,CompareOperator.Like), f.Comparison("UID_UNSRootB", "XXXXXXXX-XXXX-XXXXX8da3-062ed9d20fc9", ValType.String,CompareOperator.Equal))

ErrorMessages [System.ArgumentNullException] Value cannot be null.

Parameter name: source
at StdioProcessor.StdioProcessor._Execute(Job job)
at VI.JobService.JobComponents.ScriptComponent.Activate(String task)
at VI.JobService.JobComponents.ScriptComponent._CsvExport(String fileName)
at VI.DB.Scripting.ScriptRunner.Eval(String key, Object[] parameters)
at VI.DB.Scripting.ScriptClass.get_Item(String function)
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)

Parents Reply Children
No Data