Thanks guys! Ken, you totally changed the query. It was in the basic format that i needed. I'm looking for all the people who withdrew and then RE-enrolled. Thus...

Here is the data that i need help with.

E stands for Enrollments/Re-Enrollments

W stands for Withdrawals

This is a school with students enrolled. What I'm looking for are the students that...

thanks!

I'm going to find the first occurenc of a number and then count based on the occurence of dashes. If there is one dash such as 03-10, then i will...

Yes, intermixed with words. Example: "Ted was born 12-02-98 at hospital."

How much worse can you get? lol.

I'm looking at the data in the table and i see the problem (I THINK), RTRIM and LTRIM did not remove the square characters at the end. Evidently they didn't...

I don't care about the order. Only that it count the items the are alike. For some reason, it gets to certain records that are alike and start OVER at...

there are no triggers, no constraints or anything on this table. I've expanded the column list and I've tried to do TRIM functions on the information and i get teh...

Fantastic! IT WORKS!

Now all i have to do is create a query that will generate this query which should be quite easy.

thanks!

I think this might be it. Thanks! I'm going to give it a try. I didn't know i could use the LIKE operator in the Join...ON clause. I had...

I gave you in that second post, what i needed. This table has numerous columns that are not intuitive. These databases have nothing in common except for the subjects...

I'm trying to create a query that creates another query to be executed by other users. The query I'm actually working with is at the bottom of the last post....

Thanks guys! This was fantastic!!! I didn't understand everything at that link above, Seth, but all of this has helped me with a much more difficult query today. I couldn't...

So all i needed was a self join!!! I've done self joins but since all of this is still new to me, i get confused from time to time...

By the way i do have some William Smiths and some are ambiguous. I don't know what will happen when i need to join them. Maybe I'll just exclude them...