>>>>
>>>>REPLICATE(' ',10-LEN(ALLTRIM(REFERENCE)))
>>>>
>...
>>>>Now the above code does not work. The SQL Select returns the error:
>>>>
>>>>String is too long to fit.
>
>>>>If I change the 10 in the above REPLICATE with 15, no error.
>>>>REPLICATE(' ',15-LEN(ALLTRIM(REFERENCE)))
>>>>
>Just a thought (hope nobody elese in the thread below also has already mentioned it)
>this error can crop up with negative 2nd parameter. so if somewhen len (alltr()) .EQ. 11...
>
>HTH
>thomas
This was not the case. I actually checked all the value in the table. The table is somewhat small, only about 20 rows, so it was easy to spot this. Plus, up until yesterday, the value in the field could not be more than 10 characters, since this was the length of the field. When I changed the length of the field from 10 to 15, the problem started.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham