Search

• Vijayalakshmigopalakrishnan

  Newbie

  Points: 1

  More actions

  May 30, 2007 at 7:09 am

  #174458

  In search will it be possible to order the items like this?

  I am having a column "Description".If i give the search letter as 'B' The description column should list the descriptions starting with B first and then the rest.

   

• Tomm Carr

  SSCertifiable

  Points: 5426

  More actions

  June 1, 2007 at 12:46 pm

  #710414

  This will do what you want:

  Declare @Letter char;
  Set @Letter = 'B';
  
  Select  Description
  From    TheTable
  Where   Left(Description, 1) >= @Letter
  Order By Description;
  

  However, it's going to be a performance pig and there's not really a lot that can be done about it.

  Tomm Carr
  --
  Version Normal Form -- http://groups.google.com/group/vrdbms