CAST( > SUBSTRING( > CAST(ISNULL(CAST([Defect Description] AS VARCHAR(50)), ' ') AS CHAR(50) ) > ,4,50) >AS CHAR(50) ) >>>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:
>>CAST(ISNULL(CAST([Defect Description] AS VARCHAR(50)), ' ') AS CHAR(50) ) >>>>