I was wondering if someone could help. The following query is has error
case when [Time Taken for First ] >'24:00'
'>24' else 0 end as '1st assess',
from [dbo].['assessment ']
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value '>24' to data type int.
The column is nvarchar(255)