There is only one column of data in the database. Every row in the column is separated by | so | would be comparable to a column with 01J416781 from...

That would work if I were looking for '01J416781' however the first 9 characters vary for each row of data so the Select from could result in '01J416781' or '02J517792'...

Here is the attachment.

opc.three, thanks for your response. I've attached what the import preview looks like. The rows with spaces result in NULL value entries when I SELECT ALL from the Sandbox table.

Thank you all for the samples, dwain.c I utilized your excerpt and it worked for me. I appreciate everyone's help!

Thank you both for the help, dwain I've used your example for getting the column information. It works great however it returns rows that begin with a '/' too which...