<div>
CHARINDEX(SUBSTRING(serial<wbr />_number,5,<wbr />1), 'ABCDEFGHJKLM') AS [MONTH]
</div>


<div>
<div class="content wysiwyg-content">
Hi I was asked to come up with code to convert letters of the alphabet to months of the year which I did no problem. But then they &nbsp;came back to me and said I needed to skip the letter &quot;I&quot; &nbsp;in the process. I am stumped. If anyone can help I would sure appreciate it. <br />
<br />
Data is 7115A12345. &quot;A&quot; is the month in this serial number that we want to convert to the month number but we need to skip &quot;I&quot; in the process<br />
<br />
(ASCII(SUBSTRING(serial_nu<wbr />mber,5,1))<wbr />- ASCII('A') + 1) &nbsp;as [MONTH]
</div>
</div>


Hi I was asked to come up with code to convert letters of the alphabet to months of the year which I did no problem. But then they  came back to me and said I needed to skip the letter "I"  in the process. I am stumped. If anyone can help I would sure appreciate it. 

Data is 7115A12345. "A" is the month in this serial number that we want to convert to the month number but we need to skip "I" in the process

(ASCII(SUBSTRING(serial_number,5,1))- ASCII('A') + 1)  as [MONTH]

Skip a letter in the alphabet in SQL query

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.