• Hello Phil,

    What data-types are the CRef column and @CRef variable?

    My example would only work for character data-types e.g. it won’t work if zeros are being passed in.

    Regards,

    John

    www.sql.lu
    SQL Server Luxembourg User Group