I only want the first 50 bytes of the filed :(

My database has chinese characters in.
Eventually I need to only get the first 50 bytes of the data field, but somehow, I use len('==data==',50), it would catch 50 chinese characters which make 100 bytes ...
can anyone help me?
Thank you very much no matter what the result is ;)I'm not sure exactly what you want, so these are guesses. If you want the first 50 characters of an NCHAR, then you can use Left(@.v, 50). If you want the first 50 bytes of it, you can use Left(@.v, 25).
If you want something different... Post again with a better description and we'll take another shot!

-PatP