Many thanks, Mike, Buddy, Dawn, Larry, Stephen, Alastair
Just what I needed I should explain use: This is to remove a minus sign
which is the first digit of a longitude field and leaving the minus sign in
the field moves the location 180 degrees around the world to Africa.
Thanks again to all of you for the response;
George
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, June 19, 2008 10:04 AM
Subject: [RBASE-L] - RE: SGET use
UPDATE tablename SET yourcolumn=(SGET(yourcolumn,((slen(yourcolumn)) -
1),2))
