SQL - text conversion

Question

I want to select some values from a table . I want a text output . Now what iam doing is iam writing a procedure to convert the selected values into text . But its really time consuming . Is there anythng , means any system functions or sp's in SQL to implement this....?

Answer 1

Do you mean something like CAST(MyCol as varchar(50)) ?

Answer 2

Or something like this select CAST('some test string' AS ntext) Microsoft has a graph of valid casts in sql-server at http://msdn.microsoft.com/en-us/library/ms187928.aspx