XML Select "TYPE=" or Version=""
How can I take my code below and when there's no OrganizationalType return this
<OrganizationalType Type="NOType"/>
Instead of this
<OrganizationalType />
Select blah...blah...blah...,debtOrganizationalType 'Debtors/Names/IndividualName/OrganizationalType' from research.dbo.r_data_ucc where debtLastName Like 'B%' for xml path('Record'
Microsoft SQL Server 2005Microsoft SQL Server 2008Microsoft SQL Server
Last Comment
Larry Brister
8/22/2022 - Mon
derekkromm
Select blah...blah...blah...,
isnull(debtOrganizationalType, 'NOType') 'Debtors/Names/IndividualName/OrganizationalType'
from
research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record'
Larry Brister
ASKER
derekkromm
That returns
<OrganizationalType>NOType</OrganizationalType>
isnull(debtOrganizationalT
from
research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record'