I have something wrong with my syntax.
I have a char (don't ask me why it is char but it is) column with data being in this format:
I need to select digits 4, 5, 6 to get a range
eg xxx700xx to xxx30xx
So far I have this but I am getting errors.
where cast(Substring (BusinessUnitCode,4,3) as numeric,12, 0)) between 700 and 730
Any idea where I am going wrong.