--Related those data do not meet the date format
SELECT LEFT (NO, 4) '-' Substring (NO, 5, 2) '-' Right (No, 2) from Rav WHERE Isdate (Left (NO, 4) '-' Substring (No, 5, 2) '-' Right (NO, 2)) = 0SELECT CAST (Left (NO, 4) '-' Substring (NO, 5, 2) '- Substring (NO, 7 2) AS datetime) from RAV
