question about display mask & select number N to M records

Microsoft SQL Server

Two questions:

1. With SQL, how can I setup display mask for value:

eg. display 100000 as $100,000

2. How can I select number N to M records in a table.

eg. select No. 50 - 100 records from a table. ( not top 50)

Guyang
(a) I wouldn't rely on Enterprise Manager for data viewing / modification...
use a development tool for that, like Query Analyzer.

(b) there is no such thing as a "display mask" in SQL Server... this is
something that cute GUIs do. The data is not stored that way; if you want
it to be *presented* that way, write a view, e.g. SELECT CONVERT(VARCHAR,
moneyColumn, 1) FROM table


SELECT TOP 50 * FROM
(SELECT TOP 100 * FROM table
ORDER BY some_column) x
ORDER BY some_column DESC

If you really need it to come back 50 -> 100, then

SELECT * FROM
(
SELECT TOP 50 * FROM
(SELECT TOP 100 * FROM table
ORDER BY some_column) x
ORDER BY some_column DESC) y
ORDER BY some_column