Results 1 to 6 of 6

Thread: get part o fmy name

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    get part o fmy name

    Hi ,
    I have some old data, like ck/ST/2345RT/1994, dk/HK/678o/1997,
    Want the user give their name is that a way to automatically input 1994, or 1997 into year column? How to do that??
    Thank you
    ________
    Portable Vaporizer
    Last edited by sql; 03-06-2011 at 01:40 AM.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    What's rdbms you using? What's table schema?

  3. #3
    Join Date
    Jul 2003
    Posts
    421
    Hi ,
    I use SQl200, Name and year are colum in table, the user use interface to insert , for some over 2000 data, I want to use code to handle to input in year column.

    thank you
    ________
    Toyota chaser specifications
    Last edited by sql; 03-06-2011 at 01:41 AM.

  4. #4
    Join Date
    Feb 2003
    Posts
    1,048
    What part of ck/ST/2345RT/1994 and dk/HK/678o/1997 is the name?

  5. #5
    Join Date
    Jul 2003
    Posts
    421
    The whole thing is name.
    ________
    Volcano Vaporizers
    Last edited by sql; 03-06-2011 at 01:41 AM.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Then you can put it in name column then extract last 4 characters into year column.

Posting Permissions

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