Case sensitive data

[#1]

Hi ,

I have a data column name city where we have citynames. This data table having the city names in different cases e.g. Delhi, delhi, DELHI. My qv selection field is treating this as three different citynames, I want to select all the data associated with city - Delhi.

How can I define to treat data irrespective of case sensitive

Thanks

[#2 · Accepted solution]

Hi

You can use capitalize(Cityname)

Anders

[#3]

Hi,

You can use the string functions like Upper, Capitalize and Lower to convert in single String format at the script level.

[#4]

Thanks Anders

[#5]

thank