Member Avatar for Vamshi_4

select * from CNPSCAR.HRZ_data where EMPLOYEENUMBER like ('%1064525','%6529623','%2264218','%1065793','%2264129','%5372488','%2062550') when executing this command i am getting error missing right parenthesis. Syntax and command looks correct can anybody help in fixing this.

  • 2 Contributors
  • 1 Reply
  • 173 Views
  • 6 Minutes Discussion Span
  • Latest Post Latest Post by pty
Member Avatar for pty

Like doesn't support multiple conditions, you need to use or.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.