SourceCode/PROMS/SQL/FMTXMLGetSeperator.sql

6 lines
165 B
SQL

Select distinct
v.value('./@Sep', 'varchar(255)') Sep
FROM Formats
CROSS APPLY Data.nodes('//*[@Sep]') TempXML(v)
where v.value('./@Sep', 'varchar(255)') like '%\%'