大写字母或小写字母转换为数字A-->1,a-->1;B-->2,b-->2;C-->3,c-->3;...Z-->26,z-->26
如果非字母转换为-1
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Insus.NET
-- Blog: https://insus.cnblogs.com
-- Create date: 2019-05-23
-- Update date: 2019-05-23
-- Description: 大写字母或小写字母转换为数字A-->1,a-->1;B-->2,b-->2;C-->3,c-->3;...Z-->26,z-->26
-- 如果非字母转换为-1
-- =============================================
CREATE FUNCTION [dbo].[svf_ConvertLetterToNumber]
(
@letter CHAR(1)
) RETURNS INT
AS
BEGIN
DECLARE @ascii INT = -1
IF LEN(ISNULL(@letter,'')) > 0
BEGIN
IF ASCII(@letter) % 65 + 1 <= 26
SET @ascii = ASCII(@letter) % 65+ 1
IF ASCII(@letter) % 97 + 1 <=26
SET @ascii = ASCII(@letter) % 97 + 1
END
RETURN @ascii
END
GO
Source Code
演示：
SELECT
[dbo].[svf_ConvertLetterToNumber]('A') AS [A],
[dbo].[svf_ConvertLetterToNumber]('a') AS [a],
[dbo].[svf_ConvertLetterToNumber]('B') AS [B],
[dbo].[svf_ConvertLetterToNumber]('b') AS [b],
[dbo].[svf_ConvertLetterToNumber]('C') AS [C],
[dbo].[svf_ConvertLetterToNumber]('c') AS [c],
[dbo].[svf_ConvertLetterToNumber]('Z') AS [Z],
[dbo].[svf_ConvertLetterToNumber]('z') AS [z],
[dbo].[svf_ConvertLetterToNumber]('@') AS [@],
[dbo].[svf_ConvertLetterToNumber]('$') AS [$]
GO
Source Code
关于找一找教程网
本站文章仅代表作者观点，不代表本站立场，所有文章非营利性免费分享。
本站提供了软件编程、网站开发技术、服务器运维、人工智能等等IT技术文章，希望广大程序员努力学习，让我们用科技改变世界。
[大写字母或小写字母转换为数字]http://www.zyiz.net/tech/detail-111889.html