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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.