Use 'in between' with varchar (sql server)

Question

Using SQL Server 2005 Express.

(
    CONVERT(VARCHAR(8), R.reviewStart, 108) between CONVERT(VARCHAR(8), M.meetingStart, 108) and CONVERT(VARCHAR(8), M.meetingEnd, 108) OR
    CONVERT(VARCHAR(8), R.reviewEnd, 108) between CONVERT(VARCHAR(8), M.meetingStart, 108) and CONVERT(VARCHAR(8), M.meetingEnd, 108) OR
    CONVERT(VARCHAR(8), M.meetingStart, 108) between CONVERT(VARCHAR(8), R.reviewStart, 108) and CONVERT(VARCHAR(8), R.reviewEnd, 108) OR
    CONVERT(VARCHAR(8), M.meetingEnd, 108) between CONVERT(VARCHAR(8), R.reviewStart, 108) and CONVERT(VARCHAR(8), R.reviewEnd, 108)
)

Will the “between” still have the expected behavior after the datetimes have been converted to varchar?

thanks

Answer 1

Yes, depending on what you mean by expected behavior. The BETWEEN statement treats these operands as varchars and applies the appropriate comparison rules:

BETWEEN returns TRUE if test_expression is greater than or equal to begin_expression and less than or equal to end_expression.

, . , . CONVERT 24- ?

, varchars.

, , WHERE false (, ).

, . , ?

Answer 2

:

R.reviewStart >=  DATEADD(day, DATEDIFF(day, '19010101', M.meetingStart), '19010101') 
and R.reviewStart < DATEADD(day, 1+DATEDIFF(day, '19010101', M.meetingStart), '19010101') 

( : UDF ) .

Answer 3

, , SQL 2008 - t , , . 2005 .