All is working as expected, thanks again
TSQL:
where parcel_key >= '1720305TH00000000' and parcel_key <= '18203030099999999'
Config:
{
"fieldObj": {
"name": "PARCEL_KEY",
"label": "PARCEL_KEY",
"shortType": "string",
"type": "esriFieldTypeString"
},
"valueObj": {
"value": "Low Parcel Number"
},
"prompt": "PARCEL_KEY is >=",
"textsearchhint": "Low Parcel Number",
"sqltext": "Upper(PARCEL_KEY) >= Upper('[value]')",
"operation": "stringOperatorIs",
"required": true
},
{
"fieldObj": {
"name": "PARCEL_KEY",
"label": "PARCEL_KEY",
"shortType": "string",
"type": "esriFieldTypeString"
},
"valueObj": {
"value": "High Parcel Number"
},
"prompt": "PARCEL_KEY is <=",
"textsearchhint": "High Parcel Number",
"sqltext": "Upper(PARCEL_KEY) <= Upper('[value]')",
"operation": "stringOperatorIs",
"operator": "AND",
"required": true
}