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