I am doing a query to select wearers by size from a wearer table.
I need to display + or - a half size for each wearer i.e. if they are a size 7 then i need to display 6.5, 7, 7.5.
I am thinking and trying it with a case statement.
Would this be a good idea or is there ant better ways?
Thanx a lot.