Access to SQL Server conversion

[Bob1129]

I'm converting an Access db to SQL Server. Several of the Access queries contain FORMAT in the select list such as

Format([Gross_Property_Area],"#,###&quot AS [Gr Prop Area]

Does T-SQL have anything equivalent or should the formatting be done in the application?

Also, ACCESS has an aggregate function FIRST. How should this be handled in SQL Server?

 

[tlbroadbent]

The nearest equivalents to Format are the Convert and Cast functions in T-SQL. They are detailed in SQL Books Online.

There is no equivalent to First in T-SQL. By definition SQL record sets are unordered. There is no first or last row. However, if the rows have a datetime column or an auto number (identity in SQL Server) the Min function provides a near equivalent. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.