Skip to Content
0
Former Member
Jun 05, 2008 at 06:05 AM

Confused on SQL Expressions

18 Views

(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.