Select case wmode when 'inbetween' then 'Between ' +convert(varchar,wvaluemin )+ ' &' +convert(varchar,wvaluemax) else 'Greater then' + convert(varchar,wvaluemax) from table
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)