Good afternoon everyone: I am working with Myron at the Sun City West Posse in Sun City West, Arizona. I am trying to update a field in my table using that field and concatenating something to it.
In Excel, it would look like this: Field 1 Field 2 Smith a.4503 13566 Jones Road 13566 Jones Road UNIT 4503 concatenate(field 2," UNIT ",right(Field 1),4) UPDATE tableName set field2 = (Code needed here) Where I am trying to add the text field 'UNIT' and the last 4 positions of Field 1 to the existing field 2 in the existing table. I couldn't find a concatenation function or a function capable of grabbing the last 4 characters of another field. Is there a way that this is possible? Thanks, Larry Haas -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CAB3VSUX1V%2BOtARHoaU0o5%2BcHZ0qNw9DmEAc-Nd60wJJ4-iX4Tw%40mail.gmail.com.