Sorry, missed it!

Why does the below code not replace the value with 100? Not sure what I'm doing wrong. The value still remains 50 after modify().

declare @xml xml

select @xml =...

The explaination should have been:

Since col2 is used in the WHERE clause and happens to be a null value and since null cannot be compared to other values, the col1...

create table test (id int,countries varchar(25))

insert into test values(100,'IN, AU, GB, FR')

insert into test values(101,'GB, FR, IN')

insert into test values(102,'IN, AU')

insert into test values(103,'AU, GB')

insert into test values(104,'GB, FR, IN,...

1) use master

select * from sysobjects so where name like 'sysconst%'

go

2) use master

select * from sys.all_objects where name like 'sysconst%'

go

these two worked. thanks!!!

Thank you!

Sorry, this is the wrong forum for this question, but still.. any answers???