forum

Home / DeveloperSection / Forums / Get max value in access or sql

Ask Question

Get max value in access or sql

Manmohan Jha325315-Apr-2014
How to get Max value in Access or sql...???


column Name     :- receipt_no
column datatype :- nvarchar

receipt_no value is 1 to 1945

I am trying but result is wrong...
every time return 999(because 9 is grater than 0 to 9 for ascii reason )...

Thanks & regards
Manmohan Jha
c#c# 
Updated on 29-Apr-2014
Manmohan Jha

Manmohan Jha

Follow

Can you answer this question?

Answer

3 Answers

Manmohan Jha

Manmohan Jha

29-Apr-2014
I've solved this myself...

Access Query is :- SELECT Max(Val(receipt_no)) AS rcptno FROM Receipt
Manmohan Jha

Manmohan Jha

16-Apr-2014
I use this query multiple time, but not work in access
i also use:-
Select max(Cast(receipt_no as int)) From Receipt

Both not working in access db
Why???/
Chris Anderson

Chris Anderson

16-Apr-2014
You need to convert your nvarchar datatype to int before calling max function. The working query given below:

Select max(Convert(int,receipt_no)) From Receipt

Liked By