Afternoon,

I currently have two different types of data in my report:

1) {Letter}:\ (E.g. C:\)

2) {Letter}: (E.g. C:)

I want to exclude the first option using "??\" but it throws up a SQL Syntax error.

I've been able to find a workaround for this scenario, using ?:?, but wondered if there was any reason you can't use \ in a LIKE formula?

Hi DBlank,

That's strange! The formula used is

not ({TableName.FieldName} like "??\")

Which then displays two errors. The first one is:

"Failed to retrieve data from the database." and gives the option to click 'Ok'.

Once clicked the following error appears

"Failed to retrieve data from the database. Details: 4200. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "_\')' at line 1."

this only happens when a '\' is at the end of a LIKE clause..

No this is in the select expert

can it be moved to a crystal formula and then use that result in the select?

can you use right({field},1)="\"