USE tempdb
GO

if object_id('temp','U') is not null drop table temp

CREATE TABLE temp( idCourse INT, Libelle VARCHAR(300))
GO

CREATE TRIGGER compare 
ON temp
INSTEAD OF UPDATE 
AS
BEGIN
 -- check if there is one single row where the value of column Libelle has changed
	IF EXISTS 
		(
			SELECT 1 
			FROM DELETED d 
			INNER JOIN INSERTED i ON i.idCourse = d.idCourse
			WHERE i.Libelle <> d.Libelle
		)
	BEGIN
		PRINT 'FIRE STORE PROCEDURE'
	END
	ELSE
	BEGIN
		PRINT 'NOT FIRE STORED PROCEDURE'
	END
END
GO

INSERT INTO temp
SELECT 1,'1' UNION ALL
SELECT 2,'2'

UPDATE temp 
SET Libelle = Libelle+1 

UPDATE temp 
SET Libelle = Libelle+1 
WHERE idCourse = 2

UPDATE temp 
SET Libelle = Libelle
WHERE idCourse = 2

UPDATE temp 
SET Libelle = Libelle+1 
WHERE idCourse = 3

string val = strtxt.Text.Trim();
        if (val.Contains("N") == true && val.Contains("E") == true && val.Contains("M") == true && val.Contains("H") == true && val.Contains("T") == true && val.Contains("V") == true && val.Contains("L") == true && val.Contains("C") == true)
        {
            string[] pvalues = val.Split(new char[] { 'N', 'E', 'M', 'H', 'T', 'V', 'L', 'C' });

            foreach (string s in pvalues)
            {
                if (s.Trim() != "")
                {
                    lstsplit.Items.Add(s);
                    lblmsg.Text = "split succesfully";
                }
            }
        }
        else
        {
            lblmsg.Text = "split cant be done";
            
        }