Re: [RBASE-L] - Concatenation in an update statement

col 2. > > UPDATE TableName SET + > Col2 = (Col2 & 'UNIT' & (SGET(Col1,4,((SLEN(Col1)) - 4))) ) > > The only thing I'm sure of is the parenthesis are balanced. :) > Doug > > On 4/28/2024 4:43 PM, Larry Haas wrote: > > Yes, but it is not a numeric field. > >

Re: [RBASE-L] - Concatenation in an update statement

leName SET + > Col2 = (Col2 & 'UNIT' & (SGET(Col1,4,((SLEN(Col1)) - 4))) ) > > The only thing I'm sure of is the parenthesis are balanced. :) > Doug > > On 4/28/2024 4:43 PM, Larry Haas wrote: > > Yes, but it is not a numeric field. > > Larry > > On Sun, A

Re: [RBASE-L] - Concatenation in an update statement

ith functions, I think; just need more info. > > Doug > > > On 4/28/2024 3:56 PM, Larry Haas wrote: > > 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 fie

[RBASE-L] - Concatenation in an update statement

n 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 Goo

Re: [RBASE-L] - Doing a replace in a data field in RBASE

Thanks so much. Exactly what I need. Larry Haas On Tue, Aug 31, 2021 at 9:28 PM Bruce Chitiea wrote: > Search the Help feature for the ‘SRPL’ function: (SRPL(columnName,’Ln‘, > ‘Lane’,1)) > > Note, the “1” forces a whole-word search so that ‘Kiln House’ remains > untouched. &g

[RBASE-L] - Doing a replace in a data field in RBASE

"Mirage Ln", etc.). I would like to mass blast this field by changing all of my "Ln"s to "Lane". Would someone know how I could accomplish that? Thanks, Larry Haas -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --