Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Increment a number within a string
Message
De
04/12/2007 14:03:50
Greg Rowe
Memphis Police Department
Memphis, Tennessie, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Increment a number within a string
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01273115
Message ID:
01273115
Vues:
59
I need to imcrement a number within a string such as ME20070019. I need the ME to remain as a constant. The 2007 is the current year. I need to be able to increment the 0019 by one for each time the record is written to the file.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform