(Actually, CR10, but I don't see a forum for it here...)
I just realized that I can use StartsWith in Crystal to get this functionality, but I still want to figure out how I could make it work, if at all.
<!
break
>
I have an Oracle query that contains the following expression:
<pre>Medicate.gpi like '65%'
OR Medicate.gpi like '6299%'
OR Medicate.gpi like '6010%'
OR Medicate.gpi like '6020%'
OR Medicate.gpi like '6099%'
OR Medicate.gpi like '57%'</pre>
I tried to put that into a SQL Expression, but got various errors, such as "FROM keyword not found" or "missing right paren". Should this have worked? Would it have worked if I had written it a different way? Thanks.