Get Maximum Numeric Value From Alpha Numeric Row
select max(Convert(int,AlphaNumeric_Field))+1 from Table_Name where ISNUMERIC(AlphaNumeric_Field) = 1
Labels: Maximum in AlphaNumeric column., Sqlserver
posted by Mohan @ 5:15 PM
01 October 2010
Previous Posts
- Search Text in All Columns in Sqlserver Database
- Like operator for date in sqlserver
- Multiple rows in a single row with separator in Sq...
- How to join tables from different servers?
- DataGridView add Column and row Programatically in...
- Call SELECT Stored Procedure in c#.net
- Marquee in c#.net windows Application
- Compare 2 different dates without seconds in sqls...
- Sending Email By using C#.net
- Find and replace in Word Document
Subscribe to
Posts [Atom]
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home