What does this SQL-Server syntax do? How to convert into Teiid SQL version?

Asked Jan 26 '16 at 09:22

Active Jan 26 '16 at 09:37

Viewed 120 times

This is a part of sql syntax,

CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), HIADDITIONAL, 2))
-- HIADDITIONAL is varchar

What is the syntax supposed to do?

Update

The sql is sql-server syntax. How to convert the syntax into teiid version?

edited Jan 26 '16 at 09:37

asked Jan 26 '16 at 09:22

reuseman

2

https://msdn.microsoft.com/en-GB/library/ms187928.aspx, You could just look it up. – Jodrell Jan 26 '16 at 09:25
converting `HIADDITIONAL` to `varbinary(max)` first and then convert it (the result) to `varchar(max)` , that is the process of that syntax.. – japzdivino Jan 26 '16 at 09:27

0 Answers0