You may come across a situation, where you need alternate to the \u201clike\u201d keyword of SQL, that is to search for sub-strings in columns of the table.<\/p>\n
The one way to achieve it to use instr() function, instr() function takes 3 parameters in account.<\/p>\n
Syntax : instr( rank, string, sub_string )<\/p>\n
The instr() returns 0 if it does not find the match.<\/p>\n
Now how to apply this to the table? As the instr() function is of x3 so its simple to apply.<\/p>\n
Eg : <\/strong>Filter[ZCT] Where instr(1,ALLOTEDTO,”Ram”) <> 0.<\/p>\n where 1 is the start position to look for sub-string, ALLOTEDTO is the column name which consists of the String and the last parameter is the sub-string itself. This will give you all records from the table where ALLOTEDTO column consists sub-string “Ram”<\/p>\n which is equivalent to.<\/p>\n Select * from ZCT where ALLOTEDTO like ‘%Ram%’.<\/p>\n Note:\u00a0 <\/u>\u00a0<\/strong>Instr() function is case-sensitive so always use the upper-case or lower-case function with it.<\/p>\n About Us<\/span><\/strong> Greytrix\u00a0caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our\u00a0unique GUMU™ integrations include\u00a0Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0Salesforce.com<\/a>,\u00a0and\u00a0Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for\u00a0Sage Enterprise Management (Sage X3)<\/a>. Currently, we are Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, and Asia.\u00a0We also offer best-in-class\u00a0Sage X3 customization and development services<\/a>,\u00a0integrated applications such as\u00a0POS<\/a>\u00a0|\u00a0WMS<\/a>\u00a0|\u00a0Payment Gateway<\/a>\u00a0|\u00a0Shipping System<\/a>\u00a0|\u00a0Business Intelligence<\/a>\u00a0|\u00a0eCommerce<\/a>, and have developed add-ons such as Catch\u2013Weight and\u00a0Letter of Credit\u00a0for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n Greytrix is a recognized\u00a0Sage Rockstar ISV Partner<\/a>\u00a0for GUMU™ Sage Enterprise Management \u2013 Sage CRM integration also listed on\u00a0Sage Marketplace<\/a>; GUMU™ integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on\u00a0Salesforce AppExchange<\/a>.<\/p>\n For more information on Sage X3 Integration and Services, please contact us at\u00a0x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":" You may come across a situation, where you need alternate to the \u201clike\u201d keyword of SQL, that is to search for sub-strings in columns of the table. The one way to achieve it to use instr() function, instr() function takes 3 parameters in account. Syntax : instr( rank, string, sub_string ) Rank: Integer type expression\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[118,1943,1947],"class_list":["post-8233","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-alternate-to-like-keyword-of-sql","tag-sage-x3-technical-blog","tag-sage-x3-technical-issues"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/8233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=8233"}],"version-history":[{"count":7,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/8233\/revisions"}],"predecessor-version":[{"id":29295,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/8233\/revisions\/29295"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=8233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=8233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=8233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nGreytrix<\/a> \u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation expertise.<\/p>\n