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
