Find the max(VisitID)

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

RP_DBA SSCertifiable Points: 5116 More actions · Answer 1

Think you have to convert it to a number first...

DECLARE @t_tbl TABLE (VisitId VARCHAR(50));

INSERT INTO @t_tbl (VisitId) VALUES ('1'), ('2'), ('5'), ('7'), ('11');

SELECT MAX(VisitId) FROM @t_tbl;

-- returns 7

SELECT MAX(CONVERT(INT,VisitId)) FROM @t_tbl;

-- returns 11

_____________________________________________________________________
- Nate

NineIron SSChampion Points: 12536 More actions · Answer 2

SSChampion

Points: 12536

March 7, 2013 at 7:05 am

Thanx.

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

And then I would recommend changing the datatype to an int or whatever number type makes the most sense.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.