InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 23:03:39 GMT20http://www.sqlservercentral.com/Forums/Topic1392503-391-1.aspx[quote][b]kk.86manu (12/7/2012)[/b][hr]Thanks for your replyI just have one more clarificationIF '12/07/2012'<'12/01/2013' For the mentioned condition the first value is the same and second value is greater and again the condition should not satisfyIn this case how the comparison will occur.After the first string is compared will it compare the next 2 strings?[/quote]Are you looking at those string values as dates or strings? As soon, and as told earlier, SQL will look at those as strings unless you convert them to dates using the CONVERT function. As strings, '12/07/2012' < '12/01/2013' is false. If you sort them as strings it would look like this:'12/01/2013''12/07/2012'Fri, 07 Dec 2012 03:15:16 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1392503-391-1.aspxThanks for your replyI just have one more clarificationIF '12/07/2012'<'12/01/2013' For the mentioned condition the first value is the same and second value is greater and again the condition should not satisfyIn this case how the comparison will occur.After the first string is compared will it compare the next 2 strings?Fri, 07 Dec 2012 01:37:32 GMTkk.86manuhttp://www.sqlservercentral.com/Forums/Topic1392503-391-1.aspxOr even this.[code]IF cast('12/04/2012' as datetime) < cast('03/01/2013' as datetime)select 1[/code]Tue, 04 Dec 2012 08:16:13 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1392503-391-1.aspxBecause you are comparing a string value against a string value and the first is not less than the second, you need to ensure you use the right data types.[code="sql"]declare @d1 date = '12/04/2012', @d2 date = '03/01/2013'if @d1 < @d2select 1[/code]Tue, 04 Dec 2012 08:06:31 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1392503-391-1.aspxHello All,IF '12/04/2012' < '03/01/2013select 1The above query is not fetching any result but if i use '>' condition it is giving me 1.Why?Kindly helpTue, 04 Dec 2012 07:54:11 GMTkk.86manu