I want one simple syntax without use "case when" to do the following work :

DECLARE @AllInfo xml

SET @AllInfo = '

<RooT xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >

<HID xsi:nil="true" />

</RooT>'

select

(

case when node1.value('(HID/@xsi:nil)[1]','varchar(64)') =...

hi

i think it is better to use a trigger for this goal