AND mdTitle LIKE 'a%' collate Latin1_General_CI_AI AND CONVERT(DateTime, CONVERT(Char, '24/05/1994 16:42:03', 103), 103)<=CONVERT(DateTime, CONVERT(Char, mdDob, 103), 103) AND CONVERT(DateTime, CONVERT(Char, '24/05/2000 16:42:03', 103), 103)>=CONVERT(DateTime, CONVERT(Char, mdDob, 103), 103)