KevinC. (3/8/2010)

---

erwin.oosterhoorn (3/8/2010)

---

bouarroudj Mohamed (3/8/2010)

---

CONVERT works across all platforms & has more capabilities in SQL Server is also true

That is what I am looking at as well, does this not mean the same as the given right answer?

If one has less the other must have more?

If I understand correctly, CONVERT is MS SQL specific whereas CAST is ANSI-SQL and will work on multiple platforms (i.e. Oracle, DB2, etc.).

Therefore, the above statement is incorrect because CONVERT does NOT work across all platforms (though it does have more capabilities in SQL Server).

Please correct me if I'm wrong. 😀

--

Kevin C.