-
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.
-
What's rdbms you using? What's table schema?
-
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.
-
What part of ck/ST/2345RT/1994 and dk/HK/678o/1997 is the name?
-
The whole thing is name.
________
Volcano Vaporizers
Last edited by sql; 03-06-2011 at 01:41 AM.
-
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
-
Forum Rules
|
|