Announcements
Hello, I'm trying this query but I get syntax error, can somebody help? Thank you!
select subfrom subscrwhere code in('MD','MD2')and status='S'and (notes like'%Deposit%' or notes like'%Депозит%')
Hi @iveliart
Could you please tell us what is the error message ?
Hi @iveliart ,
Can you paste the error message or check whether variable type is integer or varchar if it is integer not required ' quotes.
Regards
Ahammad Riyaz
--------------------------------------------------------------------------------If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Thank you I solved The problem by putting the text in double %(%%deposit%%)
Good to know !
Have a nice day !
Hi, the error message was just "Incorrect SQL syntax". Variable is varchar.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 355
11manish 336 Super User 2026 Season 2
M Bilal Khan 308
