I have an interesting issue that I am pretty sure others have run into. I have a column that contains alpha, numeric, and date data. I am trying to identify the different types so I can filter it a bit better and running into a wall of frustration.
This is what I have:
CASE When lp.LoanPropertyValue Between '1990-01-01' AND '3000-01-01' THEN 0
** When lp.LoanPropertyValue LIKE '%[a-z]%' THEN 0**
** Else lp.LoanPropertyValue**
Which gives me
Conversion failed when converting the varchar value '05/01/2026' to data type int.