Dividing Bytes By 1 Million To Get Megabytes In Select

Hello!





I have a table that contains a field containing the total bytes for a file. I am displaying the information in a datagrid but need to display the information in MB. If I divide by 1,000,000 in my select statement as such:SELECT cs_fileSize / 1000000 AS MB, cs_fileSize


FROM t_client_spotsI get the following results:





MB | cs_filesize


1 | 1899602


1 | 1782281





I would like the results to be:





MB | cs_filesize


1.89 | 1899602


1.78 | 1782281





Any suggestions?





Thanks in advance!!