Okay so how do I give you credit for this?

Sorry never mind i used a convert and it works fine.

Okay it is giving me an error that ntext is an improper argument for these functions.  Any idea on how to get around that?

The version is Oracle v8.1.5, what i am trying to do is query the database for specific information and send it out again. I am not putting this into...