I have been try to figure out how to measure the length of a string with Sybase.
If, for example, I have a table that has it columns difined as ...
...then using datalength(Name) with Sybase ASE 12.5 will return 4,4,6,5 as the lengths for the data of each row in my table. However, if Name is defined not as a varchar(10), but rather as a char(10), then all I am able to get back is 10,10,10,10.
I have tried len(Name), but it does not work with Sybase ASE 12.5.
What other ways are there to measure the length of strings in a non-varchar field?