check and see if the address has a comma first and then parse...

something along these lines...

SELECT

CASE

WHEN CHARINDEX(',', Address) > 0 THEN RTRIM(SUBSTRING(Address,1,CHARINDEX(',',Address,1)-1))

END Name

Are you sure there aren't...

...maybe this is a question of semantics...and we could have a whole new deviation/discussion from original thread at this point...

But I look at the...

I believe she's talking about all the "ApexSQL", "Idera" etc. that have their own forums under "third party products"...also believe that Steve must've done this with his sense of fair...

true...important or not, on my wishlist is the "read receipt" when you've read someone's pm...instead of sending it to the sender it sends it back to you confirming what you...

What - are you not getting all the checks that SSC mails to you every month...maybe they have your address wrong..

Sam - you might be referring to the "Options" tab where you can check the table scripting options to script indexes, primary keys, check constraints etc. where you get an...

Saibhushan...sorry - don't know what I was looking at...it is 39064...to make up I am providing links for 2 articles in the hope that reading them may provide better guidance...

Sounds very frustrating to say the least...wish I could say I've experienced something similar...but no...not pre and not post RG...

Saibhushan - How do you get 39064 ?! I see it being stored as 39066 and running your select displays "20061217" ?!?!

My personal best is 628,343...I have to be content with this...see y'all in the new year!

Happy Holidays!

Merry Christmas back Mike!

My vacation doesn't start until Saturday so I get some more time to at least try and beat Ron if...

tsk! tsk! How quickly are the mighty fallen...are you sending your morals on a mini-vacation ?!?!...

Your "thinking hat" is obviously one of high quality Jeff...

It doesn't however, tell you that grouping by addresses is ok, does it ?!?!

600K is pretty impressive....for the past half hour I haven't been able to get beyond 60K...will try once again tomorrow else Mike can crown you SSC King for 2006...

Frustrating isn't it ?!

After I head home from work I'm going to have a few more goes at it!