Sergey;

Perfect! Thank you!

Tom


>Try

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:
>>
>>A. Defect
>>
>>The end result should be “Defect”.
>>

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

>>