How do I Substring Character Data based on data values
Posted on 2011-04-28
Currently using ETL Tool (Oracle Data Integrator) to move data. I have a category that needs truncated, it is varchar data with mixed values (numeric, varchar).
If the value starts with a number I need to substring the first two characters
If the value starts with a character I need to substring the first character
How do i write a sql statement for my desired results, doesn't seem to work using IN with %?
11130 = 11
1075 = 10
AA123 = A
C125 = C