XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   Hello:   
      
        Suppose I have a statement like:   
   select   
    CustomerFirstName+' '+CustomerLastName as 'Name',   
    ClearedBalance Balance   
   from CustomerDetails.Customers   
      
        I wish to edit this to add an RTRIM() around the name.  Had I   
   entered this command from the start, I would have:   
   select   
    RTRIM(CustomerFirstName+' '+CustomerLastName) as 'Name',   
    ClearedBalance Balance   
   from CustomerDetails.Customers   
      
        However, unless I am careful with exactly where I position to   
   start typing "rtrim(", I may well end up with:   
   select   
    rtrim(CustomerFirstName+' '+CustomerLastName) as 'Name',   
    ClearedBalance Balance   
   from CustomerDetails.Customers   
      
        If I am going to have to put up with my code being forced in   
   capitalisation, I want it to be consistently so.  How can I force this   
   so that no matter how I enter changes, I get the capitalisation as if   
   I entered the command in one go?  It is fine if it does not happen   
   until I move off the statement.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)