Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zorlice
Starting Member
2 Posts |
 Posted - 2007-04-15 : 13:55:28
|
| I know this may be in the wrong forum, but I have a question. I am working on a system for a video store. I have rentals and sales for videos. I have set the ID fields for rentals and sales to be autonumbers and increment by 1, but I would like to have an S in front of sales IDs and R in front of rental IDs at all times. It is kind of like a constant in all autonumber ID fields. I want the S and R to be in every ID field, but the number to change. Thanks. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-15 : 14:07:22
|
| Duplicate Post: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82128[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-15 : 14:07:45
|
| You can't put character in number column, may add a flag column in the table with value of S or D. |
|
|
|
|
|
|
Constant in Autonumber ID Field