Substring Function in SQL Loader

[sambavan]

[CODE]
(City "substr(:City, 0,INSTR(:City,' ',1))",
St "substr(:City,INSTR(:City,' ',1)+1)",
Ctry
)

[code]

On this case the string before the first blank would be stored as the city and the rest from the first space would be stroed as state.

Sam