[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

alphabetically highest varchar column

Select alphabetically highest varchar value from column.       Red orange blue green.    Select blue
0
rgb192
Asked:
rgb192
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
Is it case sensitive?
0
 
tigin44Commented:
try this


select top 1 colname
from yourTable
order by  colname ASC
0
 
rgb192Author Commented:
Thanks
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now