Jim -

I don't have a 5.5 to test, but I would try the construct:

    ... LIKE CONCAT($1, '%')

and see if that is accepted.

    Richard Sims

On Jul 13, 2008, at 7:48 AM, James R Owen wrote:

After TSM v5.5.1 upgrade, the following command syntax is invalid:
        select...where...like '$1%'
This syntax was accepted in TSM scripts through TSM v5.5.0.3,
but our local scripts are broken after the upgrade.

Maybe I'm just too tired; is there a more appropriate technique to
concatenate $1 and % to enable these scripted comparisons?
--
Jim.Owen AT Yale DOT Edu   (203.432.6693)