A business analyst recently asked me three questions. The questions are: How do I convert a mmddyyyy string to a SQL Server date? How do I handle rows with missing date strings? How do I compare a converted date string from one SELECT statement to another