SQL 7: How to get formatted data

Is there a way in a SQL 7 query to have the data come back formatted?

I would like to duplicate the functions avaialable with the FORMAT command which is in Access (97) that can be included in a query (when built using VBA code), so instead of getting, for example, numbers that might have anywhere from one to 6 decimal places displayed, the numbers could all have 2 decimal places (or whatever is needed for that column). I’ve looked through the help files and some other sources and so far I have been unable to find anything in Transact-SQL that seems to duplicate the formatting capability available in Access.