Re: [SQL] Datatype conversion help

I tried select to_date(substring(to_char(yr,'0009'),2,4)||substring(to_char(mn,'09'),2,2)|| substring(to_char(dy,'09'),2,4),'MMDD'); which works fine Detlef -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Dmitry Tkach Gesendet: Donnerstag,

Re: [SQL] Merge Record in Database(SQL Statement)

Not quite sure what the question is Assuming, you would like to normalize the data, I suggest to create 4 tables: create table gpa (id integer primary key,gpa varchar(32) not null unique); create table major (id integer primary key,major varchar(32) not null unique); create table birthplace (

Re: [SQL] SQL problem: bank account

How about: select max(transaction_id) from bank_account group by customer_id Should work... Detlef -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Erik G. Burrows Gesendet: Montag, 2. Juni 2003 07:30 An: [EMAIL PROTECTED] Betreff: [SQL] SQL problem