Thanks for the quick replies! Both of these methods work well.

However, in some cases the T-SQL statement returns a 'Disabled' value. Is there a way to...

If you're just trying to get the current day's records from a date/time field, this seems to work well:

select * from SVC05000

where left(RETUDATE, 10) = left(getdate(), 10)