Mar 28/2011 String Manipulation on large data using LIKE operator or PATINDEX The idea is to perform data cleansing on the Date and Time field from different formats into a unify format such as: YYYYMMDD. Here is a sample data to be used for the data cleansing that I will perform below...