check if all characters in string are same

Question

question

aRookieBIdev asked Dec 13, '12

check if all characters in string are same

How to check if all the characters in a string are the same ? Thanks Kannan

sql-server-2008 string-function

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-12-13T11:26:22Z

Kev Riley answered Dec 13, '12

Search for a pattern where any other character is not like the first one? declare @string varchar(50) set @string = 'aaaabaaaa' select @string, case when patindex('%[^'+left(@string,1)+']%',@string) = 0 then 'All same' else 'Not all same' end

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2012-12-13T11:23:19Z

Grant Fritchey answered Dec 13, '12

The simplest way to do that is using the equals comparison. You'll know right away if two strings are different. That won't work well for large text objects.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2012-12-13T11:54:28Z

Cyborg answered Dec 13, '12

Another method


declare @string varchar(50)
set @string = 'aaaaaaaa'

SELECT CASE WHEN LEN(REPLACE(@STRING, LEFT(@String,1),'')) = 0 
THEN 'All Same' ELSE 'NOT ALL SAME' END

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question