divide column in to 2 columns were the 1st space is.
Date: Thu, 17 Jan 2008 12:36:20 -0800 (PST)
I have a address table and need to separate the address into to 2 columns via a query in a view.
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