At 12:16 PM 1/6/2009, Paul Patrick - Enrollment Management wrote:
Any ideas how to get rid of the space or a better way to accomplish this?
Hello Paul, Extra leading space is the result of +/- for all numeric data types. However, while concatenating the entire text string, you may use the (LTRIM(text)) function to achieve your goal. LTRIM trims leading blanks from text, returning a text string. Hope that helps! Very Best R:egards, Razzak.
