i have the column(char(6)) i need to remove the first char starting with 1 and last 2 chars ending with 00
need help how to write the correct select statement.
select * from table
code(char(6)) = (last two char(code)!=00 and first char(code) !=1)
Code = 240500(should be there)
99999D(should be there)
100100(should not be there)
199999(should not be there)