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
