|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
August 17th, 2004, 09:15 AM
|
|||
|
|||
|
anutomatically generated number but with prefix
Hi,
I need to automatically create a reference number (using an ID column) but it needs to have a prefix such as ABC... so the ref would be ABC<number> Is this actually possible? Thanks 
|
|
#2
August 17th, 2004, 11:53 AM
|
|||
|
|||
|
automatically!!
Lol I should learn to spell.
One thing I forgot to mention was that I want to be able to select different prefixes depending on a value selected from a drop down box in a web form... So if the user selects ABC then the ref would be ABC123 for example.... Thanks
|
|
#3
August 19th, 2004, 09:42 AM
|
|||
|
|||
|
Hi, does anyone have any idea at all about this? I've tried searching and can't find anything worthwhile... I'd really appreciate any help anyone can offer, thanks
|
|
#4
August 26th, 2004, 05:16 PM
|
|||
|
|||
|
String concatenation using single-quotes(') with the plus sign (+), and a randomizing function (RAND()).
You could create this at the user-interface, or do the same with SQL. Depends on your application and the volumes of data you're dealing with. -Blasé
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > anutomatically generated number but with prefix |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
