Jens wrote:
> Hi,
>
> don=B4t understand your question ? Where you can use it ? For example
> you can use it in selecting different nodes from an XML data(type).
>
>
> EVENTDATA().value('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(max)')
>
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---

On 27 Mar 2006 19:15:33 -0800, Shilpa wrote:

>Jens wrote:
>> Hi,
>>
>> don´t understand your question ? Where you can use it ? For example
>> you can use it in selecting different nodes from an XML data(type).
>>
>>
>> EVENTDATA().value('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(max)')
>>
>> HTH, Jens Suessmeyer.
>>
>> ---
>> http://www.sqlserver2005.de
>> ---
>
>Hey Jens,
>Thanks for the reply
>I want to know in which editor would you write the statement?
>Can you write it in Query Analyser of SQL Server 2005??
>
>Regards,
>Shilpa