Any data type can be converted to binary, and it's impossible to tell from what you have given us what data type to convert back to. I tried VARCHAR, NVARCHAR, INT, and DATETIME successfully with different results. I don't know which of those results makes sense, though. DATE failed to convert, but that could just be a result of bad sample data.
J. Drew Allen
Business Intelligence Analyst