The STUFF() is a function. It returns result of its action on a string. If you do not assign return result to anything then it does nothing.
>
>I tried this code...
>A= "1234"
>STUFF( A , 1 , 2 , "BB" )
>WAIT WINDOW A
>
>I have NO error !????? Why ?
>
>*------------
>A= "1234"
>A = STUFF( A , 1 , 2 , "BB" )
>WAIT WINDOW A
>give a good result
>
>It is good also ?
>
>BHT
>
>
>>
>>lcStr = "0000000"
>>
>>lcStr = "BB" + RIGHT(lcStr,5)
>>* or
>>lsStr = STUFF(lcStr, 1, 2, "BB")
>>...
>>
>>
>>
>>>
>>>How To Change something in a string ?
>>>
>>>A = "0000000" TO Have A="BB00000"
>>>
>>>REPLACE( A , 1 , 2 , "BB" )
>>>
>>>
>>>Bonne soirée
>>>Good evening
>>>
>>>BHT
--sb--