as long as nobody decides to delete this login

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, EM 2000 will work on SQL7 databases.

And you will see some interesting and useful improvements in EM 2000

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Can you post table structures and sample data with a further explanation?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

only when it was blank before, IIRC

Frank

http://www.insidesql.de

http://www.familienzirkus.de

This is a cross post!

I think Jonathan gave an excellent solution here

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=18145&FORUM_ID=8&CAT_ID=1&Topic_Title=Break+up+full+name+col+into+fname%2C+lname+cols&Forum_Title=T%2DSQL

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

As a former bank VP, I am highly offended . OK, I got over it.

Years...

Might be any of the reason you've mentioned or thousands of others we don't think about yet.

Call me paranoid, but for things I can influence I like a 200% security.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I don't know the origins of full text search, but I guess they were introduced when more and more complex and 'bigger' data needed to be stored in databases like...

A primary key uniquely identifies a row in a table and is used to establish relationship to other tables.

Now when your primary key is of ID and Date (btw, why...

I'm not sure about that.

Several threads have shown, that when nobody needs to remember something, nobody does. And then Mr. Murphy steps right in, and what then...

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Well, a practice example from me.

I do receive subscription mails from this site.

I have a table in SQL Server with a column named MsgNoteText. A text column which holds the...

...btw, sorry to the original poster!

I wasn't aware of the PARSENAME function.

Sounds really handy for such situations.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

This may seem easy, but is rife with potential problems. My last name is two words...

---