>>>hello Fabio
>>>thank you very much for reply
>>>the id_no field type is char & size is 12 .
>>>
>>>best reagrds
>>>Mazahir
>>
>>Mazahir,
>>Do it just as Fabio showed. Fabio's code is independant of size.
>>Cetin
>
>Hi Cetin,
>i ask the size because with ALLTRIM() he remove field alignment,
>and my first code is dependent of the alignment.
>
>Happy new year to you and your family.
>Fabio
Thanks to you too:)
With character fields I find it nonsense (think SQL server counterpart if it were a varchar < g >) to use right alignment but you're right:)
Cetin