Yeah Steve.  You type too darn fast!!!    I was still typing when you posted and...

You can do this your way by using Dymanic SQL.  But I would suggest you look for the article on the Curses and Blessings of Dynamic SQL, (the URL is...

Alright - a bit more of my ignorance.  php-based forum software?  What is php? 

Look up dynamic SQL on this site.  Please be sure to find a posting with the article title similar to "The curse and blessing of Dynamic SQL".  It is VERY...

Maybe try SELECT LEN( Name), Name dbo.SAME_NAME_DOB_GENDER and see it some other character is actually in that field....

I agree with PW.  For instance, your original code was:

select * from dbo.SAME_NAME_DOB_GENDER

where name is not NULL and name <> ''

Where is Name in your output? 

  I had similar issues when I was with a BIG ( and Nasty) credit card company and we had workers in India.  We...

If I understand you correctly, you are saying something like, row one has values, row two has values, row three is blank, row four through 20 has values.... etc? 

Or,...

But that is (potentially) the kind of reporting I am talking about.  Say 2 identity thefts happen last year and 10 happend this year.  That is a 500% increase; but...

You also may want to look up the "Inserted" and "Deleted" tables in BOL. 

Sorry, I was away for a bit.  It is a datetime datatype (I would have had to shoot myself if I had not checked that first...

We have had similar problems with SELECT INTO statements on text fields, (i.e., char, varchar, etc).  If these select statements are hardcoded, you can try specifying the same datatypes as...

Thanks, hoo-t.  I hope I did not sound dis-respectful or un-compassionate; that had to be a terrible circumstance.  We just get so inunndated with crisis and horror.  I mean, these...

Or better yet, "Answers I wish I'd given to dumb questions".  Stand by the outlet and let the battery charge!  I love it! 

What's the real likelihood of that happening?  I mean, if it were to happen to a fella, it would be devastating.  But on the other hand, is it really happening...