Thanks Lowell....let me try to be more clear.

Our project consists of using SSIS as an ETL tool (yes I know it's not really, but our company has a license for...

Thanks Wayne, I appreciate it, but I am doing this in a derived column function (along with many other conversions of types). I've found that I can take the...

I've figured this out by utilizing the Advanced Tab on the function and modifying the SQL. Thanks!