tokenizing strings in sql
Posted on 2006-06-15
I have data in an 'Address' column which needs to be migrated to new table whose
columns are now 'Address1', 'Address2', 'Address3' and 'Address4'.
could anyone help me write an sql query that can cut up a string into four component strings.
The cut token would be a new line character with any whitespace character(including other newline) to the left or right.
would be cut up into
would be cup into
Any help on this would be much appreciated