Hi all,

Is there in T-SQL an equivalent to the VFP PADL/PADC/PADR() functionality which pads a char value with spaces?

REASON: I'd like to build a concatenated item in a SELECT statement, something like this:

SELECT Field1 + Field2 + Field3 AS MyField

but I need the first two fields to be a specific length that is DIFFERENT from the field length in the table (ie, with a couple of added spaces at the end). I know I can include a SPACE( x ) in the concatenation ... but I was hoping for an easier way (g).

TIA.