Re: SQL Question

Hi Nicholas, I had the same problem about a year ago when we converted our own system. We had our names entered much the same way. We searched for an SQL alternative in vain. Perhaps there is an SPL method, but we didn't find it. I wrote an ESQL/C program that takes the data after it is unloaded from the old table and splits it into the requisite parts. I call it split_name. Hawk's Talon wrote: } Reply-To: nikel@bellsouth.net } } I have the following SQL/SPL question. } } I am pulling a field from a linked database which contains a persons } full } name, i.e. Frank, Smith Allen. I need a way to split this data into } three } variables so that I can store the information into three seperate } fields } within a table in my database. The ideal solution would be to get the } owner } of the other database to make the change, but unfortunetly, I am on } the } lower end of that power curve. } } If any one has any suggestions, I would greatly appreciate them. } } Nicholas Twerdochlib } RTC, Inc. } nikel@bellsouth.net