Unanswered: 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!