Just wanted to let everyone know I figured it out. I use a itemcnt and ssub in a while loop to build my where clause.
"That was easy" Dan Goldberg -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Goldberg Sent: Friday, November 14, 2008 8:19 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Using multi select to filter results I have a list view variable that has prefixes in it and would like to filter the db grid based on it. I can do this with complete matches but am at a loss of how to do it based on a prefix with multiselect Example Listbox ------- Gol Jon Smi I want the dbgrid to bring up everyone with the last name starting with Gol and Smi. I tried putting the list box values with % at the end and tried the command select all from customers where lastname like listof(.variablename) But that did not work. TIA Dan Goldberg
