Please help me convert this T-SQL to Teradata SQL
SET @Xml = CAST(('<A>' + REPLACE(@Germon, ',', '</A><A>') + '</A>') AS xml)
SELECT RTRIM(LTRIM(d.value('.', 'varchar(40)'))) AS order FROM @Xml.nodes('A') AS FN (d))) AS dist)
Please sign in to leave a comment.
Comments
0 comments