title: Delete alphanumeric rows SQL
body: <p>So in my database I have location codes i.e</p>
  <pre><code>0101A
  0102A
  </code></pre>
  <p>And they go upto 37X so my last location is 0137X</p>
  <p>In my physical warehouse 0101A is the bottom left and 0137X is the top right (there are more aisles but just working on 01 for now)</p>
  <p>It's a single text column, which is made up of</p>
  <pre><code>aisle(02) bay(02) level(01).
  </code></pre>
  <p>If for example I wanted to delete all locations on level X how would I go about formulating the statement?</p>
  <p>I ran it and it deleted every single location from 0101A to 0137X even though I stipulated the started location was 0503X.</p>
  <p>I have been told</p>
  <p>&quot;There is no way to consider the the separate parts of the location (aisle, bay, level) in the delete process.&quot;</p>