7 Replies Latest reply on Sep 23, 2011 10:11 AM by gigasaurus

    parsing a field in CFQUERY WHERE clause

    gigasaurus Level 1

      I have a fairly large database that I need to run queries on.  I have one field that represents where store items are stocked by aisle, section and bin. This location field is concatenated with underscore delimiters: aisle_section_bin .  An example location might be 3_25_17.


      I need to run queries where I parse this concatenated location field and essentially ask:


      SELECT *

      FROM MyData

      WHERE aisle = '3' AND section '25' AND bin = '1'


      Could someone please help me with house this would be done?


      My database is fairly large, so I need my queries to be fairly efficient so my server does not timeout.