Software (include version): DocStar 


Use Case: Using a Type ahead or an instance of needing to query a csv or other data source where the values are all CAPS, and search not using all caps results in no result. This is referencing the data source of a csv in this instance where you cannot use UPPER variable in query

Ex… JOE SMITH

  • JOE SMITH works

  • Joe Smith does not work

  • joe smith does not work


Customer: N/A


Prerequisites: N/A


Instructions:

  • Use the LCASE function in your statement - see example

    SELECT * FROM CustomerFile.csv WHERE LCASE(customername) like LCASE('%' + @CustomerName + '%')