Luis Cazares (9/29/2015)

I'm not sure if this is good or bad.

'[1-9][0-9][0-9][0-9]-[0-1][0-9]-[0-3][0-9]'

TIL 9000-19-39 is...

3 comments:

SELECT *

FROM dbo.LIKETest

WHERE ' ' + Name + ' ' LIKE '%[^A-Za-z]Richard[^A-Za-z]%';

That is insane.

'[1-9][0-9][0-9][0-9]-[0-1][0-9]-[0-3][0-9]'

TIL 9000-19-39 is a valid date.

Some people use the PATINDEX or CHARINDEX (which doesn’t...

This comes up while Googling so I will resurrect it from the grave.

This solution is for 4x4 wordsquares, not five letter. The performance will be worse with 5x5, as there...