• [font="Verdana"]

    Try this...

    declare @i varchar(100)

    set @i = '''as400'',''cps'''

    select * from t_system where systemcode in (@i)

    Mahesh

    [/font]

    MH-09-AM-8694