Thanks, Buddy - yeah, I tested for ampersand and like it better! - Brad
From: [email protected] [mailto:[email protected]] On Behalf Of Walker, Buddy Sent: Friday, April 02, 2010 10:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Stripping Leading Spaces Brad Are you looking for the function "TRIM" this will trim all leading and trailing spaces. One side note when you concatenate your strings together and you want a space between the two strings use the & and not the +. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Brad Davidson Sent: Friday, April 02, 2010 1:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Stripping Leading Spaces I believe I saw a tip in the removal of leading spaces from a text/varchar string, but cannot find it. I need to compare 2 varchar strings (vstring 1 vs vstring2) and if not a match, append vstring2 to the end of vstring1 and update the note column in the receiving table with this new value (.vstring1 +' '+.vstring2). However, vstring1 may have any number of leading spaces - all 3 entities are varchar data type (note column, vstring1, vstring2). Any tips - much appreciated! Brad Davidson
