Hi, I have successfully used the "like" operator in the report select expert:

  {table.field1} like "A*"

When I "Show SQL query" I can see the clause is included, so I assume it has been pushed down to the server, rather than being filtered by crystal. When I try to do this:

  {table.field2} like "[YN]"

the clause is also included in the query but I get no data, even though the field does contain "Y" and "N" values. Does crystal interpret the like operator correctly?



Edited by rvink - 22 Jun 2010 at 4:14pm