Help me a function in SQL Server 2008 r2

See more:

SQL-Server-2008R2

I have a table CA with this field: ID_CA, CA_NAME, TimeStart, TimeEnd
I want to set CA_NAME is 'DAY' into CA if TimeStart and TimeEnd between '6:00:00 P.M' and '5:59:59 A.M', CA_NAME is 'NIGHT' if TimeStart and TimeEnd between '6:00:00 A.M' and '5:59:59 P.M'.
I try but no luck. Thanks you!

Declare @TimeStamp Datetime, @Result int
If @TimeStamp in ('6:00:00 P.M' and '5.59.59 A.M') ==> Return @Result = 1 (It's mean true)
else return Result = 0 (It's mean flase)

Then, i can use this function to detemine DAY or NIGHT.
Thanks You !