>Hi all,
>
>How To Change something in a string ?
>
>A = "0000000" TO Have A="BB00000"
>
>REPLACE( A , 1 , 2 , "BB" )
>
>
>Bonne soirée
>Good evening
>
>BHT
Check STUFF() function in help.
Also check STRTRAN(), CHRTRAN().
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.