Case sensitive on search bar

Like (0) Share

Report

Posted on 10 Jun 2020 12:30:25 by JukeNuke

Hello, I currently have an App that is connected to a SQL database to search part numbers from SAP. The issue I am having is that when searching its case sensitive where everything has to be typed in capital letters to return results. Anyway to go about making it not case sensitive?

SortByColumns(Search(Filter([@'[ep1].[MARD]'],WERKS="1005" Or WERKS="1000", LGORT = "0001" Or LGORT= "0002"),TextSearchBox1.Text, "DISKZ","DLINL","ERSDA","WERKS","MATNR"), "DISKZ", If(SortDescending1, Descending, Ascending))

SortByColumns(Search(Filter([@'[ep1].[MARD]'],WERKS="1005" Or WERKS="1000", LGORT = "0001" Or LGORT= "0002"),TextSearchBox1.Text, "DISKZ","DLINL","ERSDA","WERKS","MATNR"), "DISKZ", If(SortDescending1, Descending, Ascending))

Categories:

General Questions