First you need a semicolon before the SQL command:
Time(subfield(CallUniversalTime, ' ' ,'hh:mm:ss')) as Time
SQL SELECT *
FROM "HN_Ondata".dbo.ODCalls where FirstCampaign = '1743'and Time > '04:00:00' and Time < '15:00:00';
Secondly - test your SQL query in SQL Management Studio (or other tool like Toad). Verify the data type of [Time]. SQL does not have a time data type, so this will be a datetime field. What is the date portion of the field? Perhaps that is why the query is failing.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein