0

This post couldnt help my problem. I try to find out how many countries start with a 'd' and have a 'n' in their name using the query.

When I type in this, WHERE CNTRY_NAME LIKE 'd%n%' I get the following Error

SQL Expression Parsing Error: syntax error, unexpected WHERE. Occurred around :
WHERE CNTRY_NAME LIKE 'd%n%'
^

Can someone tell me where the problem lies?

1 Answer 1

1

When filtering, the where keyword must not be written and the query should not be ending with ;

Try with:

CNTRY_NAME LIKE 'd%n%'

1
  • Thanks, I tried it. It worked.
    – DjaiDi
    Apr 13, 2021 at 15:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.