List:General Discussion« Previous MessageNext Message »
From:Brandon Shuey Date:December 8 1999 4:21am
Subject:Help: Is Numeric Testing!
View as plain text  
How do I grab the largest NUMERICAL value from a column that is defined as varchar(20) and
has both alphanumerical and numerical
values?

Example:
ID		Account
1		Jim
2		9987
3		Larry
4		8732
5		20333

????????????????????????

I want it to return 20333.

Any ideas?

Brandon Shuey
WebCentric Inc.
(316) 686-4811
brandon@stripped 



Thread
Help: Is Numeric Testing!(Brandon Shuey)8 Dec
  • Re: Help: Is Numeric Testing!Sasha Pachev8 Dec
  • RE: Help: Is Numeric Testing!Don Read8 Dec