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 |
|
cindylee
Yak Posting Veteran
55 Posts |
 Posted - 2005-06-26 : 22:24:27
|
| Hi guysI have column of data type int with increment option.I need to include a text "log" before this int. for ex: log1log2log3I used to do this in MS Access (using format option in autonumber).Can anyone let me know how to do it in sql server?Many thankscindy |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-27 : 01:19:23
|
| I wonder if there is such a method in SQL ServerKeep it as it is. In your presentation layer show that number by formatting itMadhivananFailing to plan is Planning to fail |
 |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-06-27 : 02:39:31
|
Have a look at this articlehttp://www.sqlteam.com/item.asp?ItemID=1417Or you could store the prefix in a different column if they can be differentOr do as madhivanan said and keep it to your presentation layerAndyBeauty is in the eyes of the beerholder  |
|
|
|
|
|
|
Format an Increment Value