SQL Server, convert an alphanumeric string to upper case alphanumeric

Question

I need code to convert '1a234grh7eg79ef' to '1A234GRH7EG79EF' in sql server.

These are very basics in sql server google it – Jun 14 '17 at 11:11 — , Jun 14 '17 at 11:11

score 0 · Accepted Answer · answered Jun 14 '17 at 11:09

0

Use UPPER function

Select UPPER(yourcolumn)
From yourtable

answered Jun 14 '17 at 11:09

Pரதீப்

score 0 · Answer 2 · answered Jun 14 '17 at 11:09

0

DECLARE @String varchar(max)='1a234grh7eg79ef'

SELECT UPPER(@String)

answered Jun 14 '17 at 11:09

2 Answers2