my apologies for obsessing over spellings since that is not an issue here...but could you please change wharehouse to warehouse ?!?!

chiming in with my 2Cs here...agree with Chisholmd as well - whenever I answer a post I always try to respond specifically to the question (unless I don't understand it...

anytime jeff!

seeing as how you always get everything right (hurry or not) this was probably a one-time catch!

this post is being answered here

..except you'd want to change the double quotes to single...

SELECT 'This is a test'

is this what you're looking for ?!

CREATE TABLE NewTable

(colOne int,

colTwo varchar(50))

INSERT INTO NewTable

SELECT colOne, colTwo

FROM OldTable

david - a function like this would count the # of uppercase instances and return you the number...you could modify it suit your needs:

<pre class="code"

CREATE FUNCTION dbo.CountUpperCase(

@String varchar(20))

RETURNS tinyint --...

shashank - again - as far as I know - this is not possible!

That being said - why would you want to change the EM display - what really matters...

afaik it is because the EM implicitly uses the "regional settings" whereas in the Query Analzyer, unless you set the connections options under "Tools" to "use regional settings when displaying...

you can use part/all of this script

Also keep in mind collations and case sensitive/insensitive databases...if that matters!!!

something similar was addressed a few days ago and the general consensus was that this should be done client-side...however, Lee did come up with a solution...

lee's solution

Thankful is what I have been every single day that I've been following the news and the devastation that katrina has left in her wake...cannot imagine what it must be...

I think this is the script that does just that...

script

have a feeling it's going to be a loooooooong wait!