SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE XML_DATA (
    info_TOL_ArticleList XML
);
INSERT INTO XML_DATA (info_TOL_ArticleList)
VALUES (N'
<LIST>
  <ELEMENTS>
    <TOL_Article>
      <fields>
        <ArtDesc>Looprooster L1100xW1100x2mm Mesh 33,33x33,33</ArtDesc>
        <ArtNr>515021111</ArtNr>
        <BasePrice>153.7500</BasePrice>
        <Qty>3.0000000000</Qty>
        <Sort />
        <Unit>st</Unit>
      </fields>
    </TOL_Article>
    <TOL_Article>
      <fields>
        <ArtDesc>FP Box</ArtDesc>
        <ArtNr>595224</ArtNr>
        <BasePrice>100.0000</BasePrice>
        <Qty>5.0000000000</Qty>
        <Sort />
        <Unit>st</Unit>
      </fields>
    </TOL_Article>
    <TOL_Article>
      <fields>
        <ArtDesc>Cable assembly Fused</ArtDesc>
        <ArtNr>595225</ArtNr>
        <BasePrice>110.0000</BasePrice>
        <Qty>5.0000000000</Qty>
        <Sort />
        <Unit>st</Unit>
      </fields>
    </TOL_Article>
    <TOL_Article>
      <fields>
        <ArtDesc>CP 01 Fans</ArtDesc>
        <ArtNr>209232</ArtNr>
        <BasePrice>4300.0000</BasePrice>
        <Qty>1.0000000000</Qty>
        <Sort />
        <Unit>st</Unit>
      </fields>
    </TOL_Article>
  </ELEMENTS>
</LIST>
');
1 rows affected

SELECT
    article.value('(ArtDesc/text())[1]', 'NVARCHAR(255)') AS ArtDesc,
    article.value('(Qty/text())[1]', 'DECIMAL(18,10)') AS Qty
FROM
    XML_DATA xd
CROSS APPLY xd.info_TOL_ArticleList.nodes('
    /LIST/ELEMENTS/TOL_Article/fields [(ArtNr/text()) = "209232"]
') x1(article);


ArtDesc
Qty


CP 01 Fans
1.0000000000