Ignore difference between small and capital letters

[#1]

Hi,

When creating a script which uses parts of the excel-filename as identification (all the files have the same filename-structure), QV differentiates between capital and small letters. Although they are the same and this difference should be ignored.

E.g.: "LETTER" doesn't equal "letter" during upload.

How can I include this in the script ?

Thanks in advance.

[alexandros17]

Use "Upper" keyword to make all words equal ...

[manideep78 · Accepted solution]

Use upper() and lower() functions in your script. so that you can convert your text data either in upper case or lower case format.

Eg:

Upper(Field_Name) as Field_Name