I want to be able to match
lower, lower, then at least 1 and up to 6 caps
so, the following strings should match:
'cyAAS'
'qmB'
'oaTMEALY'
Right now, I've got:
select blah
from blah
where MyStringCol like '[a-z][a-z][A-Z]'
or MyStringCol like '[a-z][a-z][A-Z][A-Z]'
or MyStringCol like '[a-z][a-z][A-Z][A-Z][A-Z]'
or MyStringCol like '[a-z][a-z][A-Z][A-Z][A-Z][A-Z]'
or MyStringCol like '[a-z][a-z][A-Z][A-Z][A-Z][A-Z][A-Z]'
or MyStringCol like '[a-z][a-z][A-Z][A-Z][A-Z][A-Z][A-Z][A-Z]'
I feel like a schmuck writing that code. What I'm looking for is some way of saying "any number of [these valid chars]"
Ask questions if I haven't been clear, I'll be online and respond immediately until this is sorted (or until happy hour).
Thanks,
Greg