I finally got it. This works the way I need it to:

CASE

WHEN CAS.TERM_YYYYMMDD != '' Then convert(varchar,CONVERT(DATETIME,CAS.TERM_YYYYMMDD),101)

WHEN IND.TERM_YYYYMMDD != '' Then convert(varchar,CONVERT(DATETIME,IND.TERM_YYYYMMDD),101)

WHEN CLM.TERM_YYYYMMDD_02 != '' Then convert(varchar,CONVERT(DATETIME,CLM.TERM_YYYYMMDD_02),101)

WHEN...

I didn't mean to be rude, I just have a hard time explaining!

IND.TERM_YYYYMMDD = 5/1/2015 WORKS

CLM.TERM_YYYYMMDD_02 = 9/1/2015 DOES NOT WORK

IBE.TERM_YYYYMMDD = 3/1/2016 DOES NOT WORK

With does not work I...

Thanks!

It's part of a stored proc so I need to check each of the term dates to see if it is a date and if not I need to use...