I am not getting correct results when i use len function for a very large varchar field (35000 characters). It is workong for fields that are smaller in length. Any ideas if anyone has faved this issue? Any idea on any substitute for this?
What results are you getting (error, zero, other wrong number), and out of curiosity, when do the incorrect results start coming (perhaps with any string over 32KB)?
Choose a job you love, and you will never have to work a day in your life. - Confucius
Not true, Mike. Len() counts characters, ByteLen() counts bytes, and LenDP() counts display positions (for example for Chinese double width characters).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.