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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CAB3VSUX1V%2BOtARHoaU0o5%2BcHZ0qNw9DmEAc-Nd60wJJ4-iX4Tw%40mail.gmail.com.
