SELECT	l.db_user_id,
l.db_location,
l.db_first_name,
l.db_last_name,
l.db_middle_name,
l.db_status,
l.db_school,
l.db_school_type,
r.ad_user_id,
r.ad_location,
r.ad_first_name,
r.ad_last_name,
r.ad_middle_name,
r.ad_status,
result = CASE	
WHEN l.db_user_id = r.ad_user_id AND l.db_location = r.ad_location AND l.db_first_name = r.ad_first_name AND l.db_last_name = r.ad_last_name AND l.db_status = r.ad_status AND l.db_middle_name = r.ad_middle_name THEN 0
WHEN l.db_user_id = r.ad_user_id AND l.db_location <> r.ad_location OR l.db_first_name <> r.ad_first_name OR l.db_last_name <> r.ad_last_name OR l.db_middle_name <> r.ad_middle_name THEN 1
WHEN r.ad_user_id IS NULL THEN 2
WHEN l.db_user_id IS NULL THEN 3
END
FROM student_table_1 l
FULL OUTER JOIN student_table_2 r ON l.db_user_id = r.ad_user_id

quote:

---

Originally posted by jjmusicpro

i dont think ive set collication, can i make my database always case specific?

or can i set up only certin columns like my 2 i join on to be case specific?
i only need the column i join on to be case specific

---