I have column called Shift_End in my table but the data type is nvarchar. All the values for this column are military format but nvarchar. For example like this:
So i want to pull all records where Shift_End > current datetime. If shift_end is 1600, then i want to see all records after 1600.