>Naomi,
>
>Look for a trimmed string that has not been padded out to a uniform length.
>
>I have encountered this in a poorly formed SQL WHERE clause (SELECT ... WHERE ALLTRIM(MyField) = . After a period of time the data grew and Rushmore deemed that another index be created, promptly choking on the mix of key lengths and throwing an invalid key length error.
>
>
>Jim Fisher
>
Thanks, Jim. I looked into select statements used in these methods and I don't see any alltrims there. The where expressions are FK = tcFK and iActive_Flag = 1...

If it's not broken, fix it until it is.


My Blog