New to SQL...Need help with syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lordharliquin - 23 May 2005 16:08 GMT

Can you use the And/Or operators with a Like statement?

My example: WHERE [College Courses] Like 'CHM:###*' or Like "MTH:###*'

It keeps giving me a syntax error, but I don't understand what the problem is.

Thanks for any help you can give me.

Reply to this Message

Lynn Trapp - 23 May 2005 16:19 GMT

Try this:

WHERE [College Courses] Like "CHM:###*" or [College Courses] Like "MTH:###*"

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

> Can you use the And/Or operators with a Like statement?
>
[quoted text clipped - 4 lines]
>
> Thanks for any help you can give me.

Reply to this Message

lordharliquin - 23 May 2005 16:27 GMT

Thank you so much. I can code a little and it seems simple, but I haven't
dealt with SQL before and the syntax throws me a little.

> Try this:
>
[quoted text clipped - 8 lines]
> >
> > Thanks for any help you can give me.

Reply to this Message