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

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
You don't have to. Tools->Options->Text Editor->Transact-SQL->IntelliSense.
There is an option for how to handle casing for built-in functions.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

On Fri, 24 Dec 2010 11:46:32 +0100, Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

Fine. Suppose I do not mind the capitalisation as long as it is
consistently applied: how do I assure that this happens? (The real
question.)

Sincerely,

Gene Wirchenko

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
Submit a suggestion on http://connect.microsoft.com/SQLServer/feedback/?

Sorry, I just can't stand intellisense, so I have it turned off.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

On Tue, 28 Dec 2010 21:46:01 +0100, Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

Bug report would be more like it.

I generally have it turned off in products that I use, but since
I am learning SQL Server, I have left the settings alone for now.

Sincerely,

Gene Wirchenko