Trying to pull all rows that match my criteria but am struggling since FOLIO is a varchar that may have text, but I'm filtering on a number range.
How can I tweak this sql to work properly?
I understand ISNUMERIC returns boolean, but I just can't figure out how to filter out the non-numeric values in FOLIO.
SELECT * FROM TRANSACTIONS
WHERE ISNUMERIC(FOLIO) BETWEEN 363 and 414