Ok here's the problem. Trying to write a select statement to be able to round a set of numbers to the nearest quarter of an inch. Here is what I have so far: *-------------------------------------------------------------------------* SELECT CONCAT(ROUND(inside_length + (wall_thickness * 2), 0),'\'-', mod(((inside_length + (wall_thickness * 2)) * 12), 12),'\" x ', ROUND(inside_width + (wall_thickness * 2), 0),'\'-', mod(((inside_width + (wall_thickness * 2)) * 12), 12),'\"' ) AS footprint, CONCAT(ROUND(inlet_invert - inlet_sump - base_slab_thck, 2), '\'') as outside_Bottom_Elevation, CONCAT(inlet_invert, '\'') as inlet_invert, CONCAT(outlet_invert, '\'') AS outlet_invert, CONCAT(TopofTank, '\'') AS TopOfTank, CONCAT(Rim, '\'') as Rim, CONCAT(ROUND(((inlet_Sump + base_slab_thck) - (((inlet_ko_dia - inlet_dia) / 2) / 12)) * 12, 1), '\"') AS inlet_ko_outside, CONCAT(ROUND(((outlet_Sump + base_slab_thck) - (((outlet_ko_dia - outlet_dia) / 2) / 12)) * 12, 1), '\"') AS outlet_ko_outside, CONCAT(ROUND((inlet_Sump + base_slab_thck) * 12, 1), '\"') as inlet_invert_outside, CONCAT(ROUND((outlet_Sump + base_slab_thck) * 12, 1), '\"') as outlet_invert_outside, CONCAT(ROUND(inlet_Sump * 12, 1), '\" ') AS inlet_Sump, CONCAT(ROUND(outlet_Sump * 12, 1), '\"') AS outlet_Sump, CONCAT(ROUND(inlet_Sump * 12 + (inlet_dia / 2), 1), '\"') AS inlet_cl_floor, CONCAT(ROUND(outlet_Sump * 12 + (outlet_dia / 2), 1), '\"') AS outlet_cl_floor, CONCAT(inlet_dia, '\"') AS inlet_dia, CONCAT(outlet_dia, '\"') AS outlet_dia, CONCAT(inlet_ko_dia, '\"') AS inlet_ko_dim, CONCAT(outlet_ko_dia, '\"') AS outlet_ko_dim, CONCAT(ROUND((inlet_ko_dia - inlet_dia) / 2, 1), '\"') AS inlet_invert_ko_invert, CONCAT(ROUND((outlet_ko_dia - outlet_dia) / 2, 1), '\"') AS outlet_invert_ko_invert, CONCAT(inlet_offset, '\"') AS inlet_offset, CONCAT(outlet_offset, '\"') AS outlet_offset FROM tbl_prj_dims *-------------------------------------------------------------------------*
This will get all of the values I need in decimal inches but I would like to be able to round them up or down to the nearest quarter of an inch, so the only decimal values will be .0 or .25 or .5 or .75 I'm not really sure if there is efficent way to do it and would like all of your inputs. And dont mind the first few values in feet. Those need to be like that. Thanks a lot! -Nick Stuart Filter Fodder: MySQL QUERY --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
