• I found this also. Seems to work. Takes less code.

    SELECT * FROM TABLE

    WHERE (@CUST='' OR CUSTNMBR IN (SELECT LTRIM(item) value FROM dbo.DelimitedSplit8K(@cust,',')))