TSQL - use columns as date range
It's kind of a barebone question, but...

@DateToUse is the date you are searching for.

@StringOutput is the cto column.  

I'm using the ID field as a tie-breaker in order to protect against duplicate or overlapping ranges in from/to fields.  

DECLARE @DateToUse DATE
DECLARE @StringOutput VARCHAR(50)

SET @DateToUse = '3/2/2019'

SET @StringOutput = (SELECT TOP (1) cto FROM dbo.MyTable WHERE @DateToUse BETWEEN from AND to ORDER BY ID)

PRINT @StringOutput