Hi All,
Happy New Year to Everyone.....
I have column name (EXPIRY_DATE)
ExPIRY_DATE
--------------------------
Died Aug. 20, 2012.
Died July 20, 2012
Died July 28, 2012.
Died July 27, 2012.
Died Feb. 7, 1999.
Died June 27, 2004.
Died Nov. 7, 2004.
Died Nov. 12, 2001.
Died June 20, 2003.
Died Dec. 3, 2003
Died Feb. 5, 2004.
I want to Trim out Died and have the Date Format MMDDYYYY format.
Thanks