Below, I'm trying to restrict my results in the USERNOTES field if there is
a numeric value in the first 2 characters. The ISNUMERIC part works within
the main query because I'm using the same syntax with a CASE statement. I
only get an error with my query if I add the ISNUMERIC part.
Shouldn't the ISNUMERIC part below return the record if a numerical value is
in the first 2 digits of USERNOTES field?
Error simply says "Error near ORDER BY"
WHERE (tblDowntime.DTID = 1) AND
ISNUMERIC(SUBSTRING(tblDowntime.UserNotes, 1, 2))
ORDER BY tblDowntime.StartDateTime