Select MAX no from particular column in SQL Server or MAX fuction

If we have a table design like as :

Alter table command

alter table table_name alter column membership_no int

select MAX(membership_no) as Membership from table_name