Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Red face 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

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    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!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts