Ok, i see what i did wrong. I tried to do the comparison in the where clause because i wasn't sure i could use LIKE in the ON clause

Thanks!

FYI:...

Ok guys thanks! That answers my question.

Thanks guys! I'm happy. When i looked into the SS2005 table it was in the appropriate format. thanks!

I still don't understand that chart but that is ok.

Best wishes.

I'd like for it to be in MM/DD/YY or MM/DD/YYYY format. I really don't care about the time.

Geee! A whole day has gone by. I don't know if this...

I saw that table. I didn't understand what it was saying. I've tried different formats and i get the same style each time.

I would like to format it better but...

Ok, i played with the convert function and did something like

Select dateofbirth = Convert(datetime, DateOfbirth, 1) from studentcur

and i was able to get it in the format

1971-06-10...

I think you guys answered my question. Thanks! I was wondering if this could be done while avoiding CTEs or Temp tables. I guess not. THere is no way of...

Weird guys!

Ok i tried each one of your functions returned NULL! I tried all 3. But the IS NULL did not work.

I'm satisfied. At least i was...

I don't think I've ever encountered anything like this! Makes me wonder what else I wasn't taught in school.

I'm going to try this code out. Thanks for...

Lynn, some of us are a little bit slow. Not all of us are privileged with common sense. I remember your ELSE correction, that is what eventually led to my...

Thanks Andrew, I didn't know that

Thanks! I'm going to look into this further. As stated above I was not expecting this. I will read your article. I just glanced at it but I have...

The answer so far is that none of the cells are NULL.

Here is the difference from yesterday. Yesterday I imported the data from an Excel file. Today I...

WEll I've figured out why it is turning it NULL because I'm not returning anything.

I should have and ELSE that simply returns EmergencyRelation. But i still don't know why that...

You know I developed a whole database of about 20 tables using DDL, but unless you use it all the time, it seems that its easy to forget. How much...