Here's one way to go:

Select parsename(Replace(NameCol, ' ', '.'), 0) as LastName

, parsename(Replace(NameCol, ' ', '.'), 1) as FirstName

From YourTable

How are you trying (or what are you using) to create the data profile?

Lynn: not a mistake. Darth will be back tomorrow. 🙂

Michael Valentine Jones (4/10/2009)

---

If you want to show a special status for a poster, you might consider some kind of SSC MVP status (Most Valuable Poster?) that you setup, instead...

jsanborn (4/10/2009)

---

Maybe this example will be clearer. Suppose you are doing an experiment with rats and mazes. You have a maze that a rat can find a single direct route...

Unfortunately Flo, the INFORMATION_SCHEMA views do not work...

Heh. You and Kevin really had me going there for a minute. I thought I...

I would not normally be on-line today, but I am home sick....

It is just not possible to give any kind of valid answer to a question like that without more information.

For instance, how would you answer a question like this:

I need...

Heh. I should have known that Erland would have already requested this. Between him and Itzik, I think that they must have almost 100 of these.

I am sorry it is not clear what your question is.

So far as I know, any VS.net language can use SMO because it is a set of .Net namespaces. ...

right. the problem is that what we really need in SQL is a function like this: isCastable(expression, datatype) So that we can do proper pre-testing.

Actually I think that the...

It is not clear what you want to do. Could you show us what you have so far or what you have already tried? That might help us...

That would depend of my analysis of my current resource usage and my expectations for change and/or growth in my future workloads.

You should only have to reinstall the client tools. This should not affect any of your databases (though a DB backup is always a good idea anyway).