Is there a way to convert a VIEW's DataType that is outputs?
SELECT CountryID(Integer), Description FROM Country
So the above select statement would be the view. BUT..........I need to convert for this views purposes the CountryID from INT to Varchar(6)
Weird I know, dealing with a crazy ERP system.