I need to be able to convert the contents of a LONG field type to text in an SQL select statement. I have tried converting the contents to XML first, but the query fails if there are any invalid XML characters such as "&" are in the field.
putting it simply, i want to be able to use a statement like
select field1, field2, field3, to_char(long_field) from table_name
The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.