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

From: Jeremy Smith <godtoall_at_hotmail.com>
Date: Thu, 17 Jan 2008 12:36:20 -0800 (PST)
Message-ID: <09bb9a7c-e8a2-4b1c-862c-74427a308936@m34g2000hsb.googlegroups.com>

I have a address table and need to separate the address into to 2 columns via a query in a view.

Example:

211 S. Akard Str.
2525 N. WATNEY WAY divide into 2 columns

STREET_NUMBER      STREET_NAME
211                             S. Akard Str.
2525                           N. WATNEY WAY

Is there a function to find the 1st character and get field count like in Excel? Received on Thu Jan 17 2008 - 14:36:20 CST

This message: [ Message body ]
Next message: Jeremy Smith: "Re: divide column in to 2 columns were the 1st space is."
Previous message: hjr.pythian_at_gmail.com: "Re: can someone please explain what this blog tagging this is all about?"
Next in thread: Jeremy Smith: "Re: divide column in to 2 columns were the 1st space is."
Reply: Jeremy Smith: "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