Re: divide column in to 2 columns were the 1st space is.

From: Jeremy Smith <godtoall_at_hotmail.com>
Date: Thu, 17 Jan 2008 12:58:47 -0800 (PST)
Message-ID: <c836c978-cee4-48c9-b5d5-07e5888ffeee@z17g2000hsg.googlegroups.com>

Team member help me with my issue.

Post if anyone ever needs it.

select street, substr(street,0, instr(street,' ')), substr(street,instr(street,' ')+1) from loc_address Received on Thu Jan 17 2008 - 14:58:47 CST

This message: [ Message body ]
Next message: EdStevens: "Re: truncate tables in my tablespace"
Previous message: Jeremy Smith: "divide column in to 2 columns were the 1st space is."
In reply to: Jeremy Smith: "divide column in to 2 columns were the 1st space is."
Next in thread: Brian Tkatch: "Re: divide column in to 2 columns were the 1st space is."
Reply: Brian Tkatch: "Re: divide column in to 2 columns were the 1st space is."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message