Alastair
I did remember the ltrim function just prior to getting your response . The problem I was trying to solve is that the variable nvadd4 is a street name that I am using to get the value of the 'city' name in the same table, so I 'select city into vcity from customer where address contains .nvadd4' nvadd4 is the street name without the numerice part of the address It will not return the variable 'vcity' because of the space between the actual street name and the suffix 'rd'. Would you have any comments , I have tried like, .vnvaddd4*, nvadd4% Mike From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Saturday, May 16, 2009 10:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: removing blank spaces from text field LTRIM removes leading blanks. Regards, Alastair. ----- Original Message ----- From: mike epstein sony viao office <mailto:[email protected]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Saturday, May 16, 2009 4:09 PM Subject: [RBASE-L] - removing blank spaces from text field Good morning I have done this before but can't remember how. This function set var nvadd4 text =(SSTRIP(.vadd4,'' '1234567890')) returns a value that has a blank or null space as its first character .How would one remove it . _____ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.325 / Virus Database: 270.12.32/2117 - Release Date: 05/15/09 17:55:00
