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

