string ( dd/mm/yyyy) to date sql server

EDIT: The solution is in the reference post's solution .I was careless to overlook DATETIME--> Varchar(10) `Syntax for CONVERT: ``` CONVERT ( data_type [ ( length ) ] , expression [ , style ] )` ``` I am aware of this post SQL Server (2005, 2000, 7.0) does not have any flexible, or even non-flexible, way of taking an arbitrarily structured datetime in string format and converting it to the datetime data type. So I am looking for a solution that solves this particular String format only. Let's say I have a table in sql server with field :`inputDate` in `datetime` format The following code works without convert/cast ``` SELECT inputDate FROM some_table WHERE inputDate > '01/24/2013' ``` But it won't work for ``` SELECT inputDate FROM some_table WHERE inputDate > '24/01/2013' ``` Throwing an `The conversion of a varchar data type to a datetime data type resulted in an out-of-range value` Then I tried ``` SELECT inputDate FROM some_table WHERE inputDate > CONVERT(VARCHAR(10), '24/01/2013', 103) ``` Throwing the same error Is there a way to convert string in dd/mm/yyyy to be recognize as datetime format in SQL SERVER? Or the only way, and the proper way is doing santization elsewhere?