My last problem is to LEFT Justify (which works thanks to Sergey) and begin at position 4 of a field. I have to parse something like this:

A. Defect

The end result should be “Defect”.

CAST(ISNULL(CAST([Defect Description] AS VARCHAR(50)), ' ') AS CHAR(50) )

Thank you.

Tom