# Elasticsearch String Comparison/Colation **URL:** \ **Category:** Elasticsearch\ **Created:** [September 3, 2014, 5:28pm UTC](https://discuss.elastic.co/t/elasticsearch-string-comparison-colation/19598 "2014-09-03T17:28:45Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![smonasco\_2](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@smonasco\_2](https://discuss.elastic.co/u/smonasco_2)\ **Post date:** [September 3, 2014, 5:28pm UTC](https://discuss.elastic.co/t/elasticsearch-string-comparison-colation/19598/1 "2014-09-03T17:28:45Z")
Hi, For business logic reasons I need to sync subsets of objects (percolation queries) between SQL and ElasticSearch. This includes needing to know if in Elasticsearch there exists an orphan query that needs to be deleted. As such I need to search through a range of identifiers that are case sensitive. Since it's a range and I don't know about anything outside my range I need to understand something about string orders in ElasticSearch. For instance if my range is from [a=-0/ to Bt3|] and in SQL I don't have abcd, but it exists in my query returned from ElasticSearch, I need to be able to have confidence it should be removed from ElasticSearch. I'm pretty sure abcd comes in that range in both SQL and ElasticSearch methods, but I'd like to know the comparison method so I can be sure. --Shannon Monasco -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/433c387f-0f07-464f-a120-a34df7232ac5%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/433c387f-0f07-464f-a120-a34df7232ac5%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:04am UTC](https://discuss.elastic.co/t/elasticsearch-string-comparison-colation/19598/2 "2017-07-06T01:04:37Z")