3 Replies Latest reply on Jul 11, 2007 6:39 AM by Newsgroup_User

    Select Question

    siriiven Level 1
      Say I am passing a variable through a drop down select menu to the next page and the output looks like this HB54Htg1. It is actually two variables #location##controller#. The left 4 character will always be the building code. Whatever comes after is always the controller name. I need to query to get a serial number based on what the building is and what the controller is.

      I'm having trouble writing a select statement that is something like:

      Select SN from inventory
      where location.inventory = '#left(form.controller, 4)#' and Controller.inventory = The rest of the string after the left 4 characters.

      Can anyone help me out?