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

    parsing a field in CFQUERY WHERE clause

    gigasaurus Community Member

      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.

       

      Thankyou