UPDATE : It seems Community Server stripped the actual CHAR(160) in @someStringWithPad, just so that it will be contrived append CHAR(160) at the @someStringWithPad variable. ;) Ever experienced trying the following code to trim a seemingly "space"...