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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Incrementing alphanumeric values using sql

Author  Topic 

kayinebi
Starting Member

1 Post

Posted - 2013-05-23 : 03:32:45
Hello, guys, I have a table column named GRADE_LEVEL containing the grade levels of employees but the values are alphanumeric in nature. e.g HoAGS_GL10 and PSSS_GL15 where GL10 and GL15 are grade levels 10 and 15 respectively and HoAGS and PSSS stand for their respective salary structures. My problem is how to increment the grade levels. I am having serious problems with incrementing the grade levels because they are in alphanumeric form. can any please help with how to do this? Please this is urgent. I would really appreciate it if anyone can help me.
Thanks
Kayinebi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-23 : 03:34:45
see this

http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -