As Hett replied above creating a cast is indeed the best solution if you have access to the database.