How about using LEFT or RIGHT JOIN

Thank you for your solution.

But the code is not in the same pattern, They may be 11-220, 201-223, 11-23-2.

However, this is another good solution, thank you again 🙂

This is what I'm looking for 🙂

Thank you for your quick reply.

Thank you very much

It work very well. 😀

Thank you very much for your replies.

For system function, it's very new for me and I'll find out it.

But the session that I mean is the session of the user...

Thank you very much, Jeff

I have read tutorial of '' if update()''. It's work very good.

Now I have any problem, I develop the web application and want to

send...

Now I decide the table for tracking change, including old value and new value

I wonder that if I use TRIGGER, can it tell which field is modified.

I want to keep...

Thank you, everyone

Actually I'm still a student. And as Phillip Cox said, I'm just finish the System analysis and design course.

I have learned many model, so I'm very confuse....

Thanks, all

Actually I want to keep track for security and navigation

I want the admin can tell who do what transaction and

he can find that it's possible that the person...

Thank you very much, Grant Fritchey

You give me a very good explaination, I really understand your example and your reason. :w00t:

I'll adapt your idea to my work.

THANKS AGAIN

😛

You means when the register sign up, data will be kept in the member table right?

Actually, my wonder is.. the data in member table is quite important so I...

Thank you for your inform

Thank you very much for your helpfullness, Aster.

I'll find out it 😀

To Steve Jones

My application is online so every time user click save, I'd like to do comparision in realtime.

I use ASP.NET to develop.

Is there any way to do that?

Thank...

Thank you everyone,

Now, I have another question. if I choose to store document in the database,

I found that in sql server 2005 have image datatype and varchar(max)

what the different...