Using Cast to convert nchar - > nvarchar
Posted on 2007-10-18
im a real dummy when it comes to databases and need some help with a simple query!
im trying to query a DB which has a list of "rogue" computers in the company (kinda nac solution) - but whenever i query the MS SQL Db - i get one row which is empty (THE Mac address row)
anyhows , from here to there i talked to a few guys who said there is a problem with the agent driver im using and the simplest way to ovveride this is to use the CAST command.
here is the query , how do i use cast in order to convert the ROW called MAC from nchar12 to nvarchar?
SELECT HostId,NetBiosName,Users,OSPlatform,MAC FROM Hosts