Extracting a number of characters from a field??

[kilabru]

I have two fields A & B.
A B
1234567 Holly, Robert

I want to pull the first three numbers from A and the first three letters from B and conectate them in another field. Can anyone tell me how to do this?

Thanks

 

[Valeric]

G'day mate,

Try this

This table, names, has 3 fields A, B and C. A and B have the number and char data and the concatenated result will be placed in C.

update names
set c = substr(a,1,3)||substr(b,1,3);

Enjoy.