Help with MYSQL please

[Meyer]

hi there

I am trying to import data from oracle to mysql.

the only stuble blok for me to get this data into sugar is the account number table.

This is what the table data looks like in oracle.
"ATLANTIC -209101813025 UNP 34"
This is what i need
"1813025"

I have no idea how to left or right string etc.
please help

[eggsurplus]

The string functions for 5.0 can all be found here: http://dev.mysql.com/doc/refman/5.0/...functions.html

Not sure what the standard format is that you're coming from but if it's always 15 characters in and the number will always be 7 chars long it would be SUBSTRING(account_number,16,7)

[Meyer]

i used

select Date,SERVICE_FEE,SUBSTRING(AMOUNT,2,11),SUBSTRING( REFERENCE,6,11),SUBSTRING(Reason,14,15)
from bank_file

cheers