How to use Min/Max function on varchar field? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

How to use Min/Max function on varchar field?

Author

Topic

rudba
Constraint Violating Yak Guru

415 Posts

Posted - 2010-03-23 : 10:07:14

Hello everybody,
I have table with following format. How do i use min and max functions on field1?

declare @tbl1 table
(ID INT,
Field1 varchar(20),
Field2 varchar(10)
)

INSERT INTO @tbl1
SELECT 1, 'AAAA10001','XX'

INSERT INTO @tbl1
SELECT 2,'AAAA10002', 'XX'

INSERT INTO @tbl1
SELECT 3,'AAAA10003', 'YY'

INSERT INTO @tbl1
SELECT 4, 'AAAA10004','XX'

INSERT INTO @tbl1
SELECT 5,'AAAA10005', 'YY'

select * from @tbl1

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-03-23 : 10:10:30

SELECT MIN(Field1), MAX(Field1) FROM @Tbl1

N 56°04'39.26"
E 12°55'05.63"

rudba
Constraint Violating Yak Guru

415 Posts

Posted - 2010-03-23 : 10:13:26

Got it. Thanks Peso.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources