hmmm,
so your problem, as I understand it is how to find 'ABC%', since you are looking for a way to find the special character %, but for CR, I would think, it would be just LIKE 'ABC%*', since it doesn't recognize the % as having a special meaning. In this way CR syntax mimics the Access formatting.
If you are looking for a string that starts 'ABC*' in CR, how can we get around this...How about trying CHARINDEX('ABC', {table.field}) = 1 AND CHARINDEX('*', {table.field}) = 4, though in all honesty, I don't if that would be correct for CR syntax.
Personally, I found dealing with CR SQL syntax too much of a pain, way back in CR 7, so I just write stored procs to get the data, and call them from CR. Much more versatile and does have frustrations like this.
HTH
IP Logged
