Results 1 to 2 of 2

Thread: format of char

  1. #1
    Join Date
    Jan 2009

    Unanswered: format of char

    Hi Everybody!
    How the format of char can be defined? For example, I would like to be the format of the values of S# as s001, s002, s003, etc. ( must be four characters and start with s and must increase 1 by 1) Is it possible to define that?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Based on your question at I would have to say that SQL can't do what you are describing.

    The device that you are describing is an RA Sequence. It is theoretically useful and very appealing to academics, but I don't think that it is possible to implement that concept in a system that has to deal with the real world. In the real world there will eventually be gaps caused by deleted or abandoned data.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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