SQL Server Convert case for letter that comes after - (hyphen)

Question

I need to convert case for letter that comes after hyphen (-) in all values of a column

like

Aaa - aaa
Bbbdd - bbbdd
Ccc123 - ccc123

to

Aaa - Aaa
Bbbdd - Bbbdd
Ccc123 - Ccc123

Please help!

Your pattern is static always like n characters then space then hyphen then space and n characters? — Kannan Kandasamy, Mar 30 '17 at 20:22
@KannanKandasamy not its not static it can be of any length any characters — user979189, Mar 30 '17 at 20:24

score 1 · Accepted Answer · answered Mar 30 '17 at 20:27

1

Using stuff():

declare @str varchar(64) = 'Aaa - aaa'

select stuff(@str,charindex('-',@str)+2,1,upper(substring(@str,charindex('-',@str)+2,1)))

rextester demo: http://rextester.com/CCIZDT37194

Returns: Aaa - Aaa

answered Mar 30 '17 at 20:27

SqlZim

37,248
6
41
59

score 0 · Answer 2 · edited May 23 '17 at 12:32

0

Well if the format doesn't change here's an easy way. It works for n - n characters

declare @char varchar(64) = 'Aaa - aaa'

select 
    @char
    ,substring(@char,1,CHARINDEX('-',@char,1)) + ' ' + upper(substring(@char,CHARINDEX('-',@char,1) + 2,1)) + substring(@char,CHARINDEX('-',@char,1)+3,len(@char))

Otherwise you need a UDF

edited May 23 '17 at 12:32

Community

1
1

answered Mar 30 '17 at 20:23

S3S

24,809
5
26
45

score 0 · Answer 3 · answered Mar 30 '17 at 20:31

This might help.

DECLARE @InputString VARCHAR(MAX) = 'Aaa - aaa';
DECLARE @Index INT = CharIndex('-', @InputString);
DECLARE @StringToReplace VARCHAR(3) = SUBSTRING ( @InputString ,@Index , 3 );

SELECT REPLACE(@InputString,@StringToReplace,UPPER(@StringToReplace));

score 0 · Answer 4 · answered Mar 30 '17 at 20:39

You can use upper and ParseName

select concat(parsename(Replace(v,' - ', '.'),2), ' - ', Upper(substring(parsename(Replace(v,' - ', '.'),1),1,1)), substring(parsename(Replace(v,' - ', '.'),1),2,len(parsename(Replace(v,' - ', '.'),1)))) 
    from #yourtext

Your Input table:

create table #yourtext (v varchar(100))

insert into #yourtext (v) values
 ('Aaa - aaa')
,('Bbb - bbb')
,('Ccc - ccc')

SQL Server Convert case for letter that comes after - (hyphen)

4 Answers4