Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Generate a sequence

bhushan1
New Contributor III
New Contributor III

‎03/27/2024 11:35 AM

Hi All,

We want to generate a sequence as below:
ABY8
ABY9
ABZ1
ABZ2
ABZ3
ABZ4
ABZ5
ABZ6
ABZ7
ABZ8
ABZ9
ACA1
ACA2
We have tried using systemusername generation rule for this. The autoincrement is for numbers and not for alphabet.
Is there any way we can generate this sequence?

Thanks,
Bhushan

Labels:
0 Kudos
2 REPLIES 2

dgandhi
All-Star
All-Star

‎03/27/2024 11:54 AM

As per my understanding this doesnt seem to be feasible.

 

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.
0 Kudos

rushikeshvartak
All-Star
All-Star

‎03/27/2024 12:04 PM

MySQL doesn't directly support incrementing alphabets in a sequence. You would typically handle this in application logic rather than relying solely on SQL.


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.
0 Kudos
Copyright © 2024 Khoros, LLC