Need to partition a string with unique leading numbers HELP

[Phillip Marquis]

Hello!

I am hoping this question/issue has not already been asked/addressed, if so, please point me to the thread. For the record, I can not write SQL.

My issue is:

I have a file coming into Responsys SFTP daily that a connect job grabs and puts into a supplemental table.

The file has two columns (EMAIL and COUPON_CODE). The issue with this file is that there are two coupon types in the COUPON_CODE column. One type, the code string begins with 999 and the other begins with 998.

I need the two types to be separated into their own columns in the supplemental table in Responsys.

Is there a SQL that can identify the code type (using the unique leading numbers)and create a new column for each coupon type in a supplemental table?

Please let me know if you have done this before and can provide any guidance!

Thank you!

Phill M.