How can maximum value count from varchar field

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How can maximum value count from varchar field

Message

From

10/10/2006 10:20:26

Arjun Bagojikop
Dynamic Super Software
Sangli, India

10/10/2006 10:08:14

Borislav Borissov
Microcomplex
Sofia, Bulgaria

General information

Forum:

Microsoft SQL Server

Category:

Other

Title:

Re: How can maximum value count from varchar field

Environment versions

SQL Server:

SQL Server 2000

Miscellaneous

Thread ID:

01160823

Message ID:

01160843

Views:

hi
Borislav

i have created table table1 with bill_no varchar(10)
insert records as under
1111AAAA
23000AAA
AAAA1111
22222

I Want to get max 23000 only

i have get max value in vpf like
select max(val(bill_no)) as bill_no FROM TABLE1
But i have comes problem in sql2000

Map

View

Click here to load this message in the networking platform