Home
Designing Analytics Reports
Order varchar data containing numbers and symbols
Migrateduser
<p>Good morning, all! I have a graph that has category labels that are strings, but are made up of numeric and symbol data (see pic). I would like to be able to sort them so that '<41' would appear as the top value, then follow that with the numeric categories, and finish with '>63'. I've been looking through SQL examples using CASE then ISNUMERIC, but I can't really do the sorting in the query, it would have to be done when building the chart.</p>
<p> </p>
<p>Any thoughts?</p>
<p> </p>
<p>
Find more posts tagged with
Comments
There are no comments yet