New to SQL...Need help with syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Lynn Trapp said:
Try this:

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


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


lordharliquin said:
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.
Click to expand...
Click to expand...
 
Back
Top