No Subject

[Sheri Coleman <coleman@hudce2.harvard.edu>]

Hi

I need some help and feel like I am overlooking a perfectly straight forward
way to do this.

My problem:  I need to allow my user to use a parameter to select names on
which to select in this label report.  What do I do about names with
apostrophes?  If my statement says  -- and spriden_last_name in ('Cohen',
'Jones', 'O'Hara' -- the program fails.  I need to get the name from the
user and then build the where clause dynamically.

We have functions (mini-SQRs) that we use to build these joins when using
lists but because of the apostrophe that function won't work.

I need make sure this takes into account the number of people in the list,
using '=' or 'in'.

Thanks for any ideas you may have.

Sheri Coleman
coleman@hudce.harvard.edu