• Wouldn't it be easier to just use:

    SELECT RIGHT(RTRIM(Particulars), LEN(RTRIM(Particulars)) - CHARINDEX(';',Particulars) - 1)

    FROM Sample_table

    Also, you could remove the RTRIMs if you used VARCHAR instead of CHAR...

    --
    Adam Machanic
    whoisactive