• Thank you, OPC.THREE

    create table T1(

    SL int NOT NULL IDENTITY (1, 1),

    ISDN varchar(13) NULL,

    MSG varchar(50) NULL

    )

    insert into T1(ISDN,MSG) values ('123','ABC');

    insert into T1(ISDN,MSG) values ('123','ABC');

    insert into T1(ISDN,MSG) values ('123','XYZ');

    insert into T1(ISDN,MSG) values ('124','XYZ');

    insert into T1(ISDN,MSG) values ('124','EFG');

    Now I wanna compare whether there is any similar row comprising ISDN and MSG columns.