I have a large table with two fields. one is numeric and the other text. Out of this table I need to choose the best record for a particular purpose. I would like to filter the records to display in a portal so that it would be easier to choose a particular record. This would involve searching for a string in the text field using the position function. have been able to do this with a quoted text string in the filter part of the portal setup. But it doesn't seem to work if I use a text variable or text field instead of a quoted text constant. Interestingly, I can filter the numeric field with either numeric constants or numeric fields entered into a calculation for the filter.
Anyone have any ideas?