Dotted Quad
New Member
- Joined
- Jun 10, 2004
- Messages
- 8
I'm trying to find records in which a newline character is immediately followed by a lower case character. (to find extra newlines to remove).
I tried:
like "*" + chr(10) + "a*"
but there are two problems. First it seems to match a newline followed by a capital A, second I would need to type that our 26 times to get every lowercase letter.
Does anyone know a better way?
I tried:
like "*" + chr(10) + "a*"
but there are two problems. First it seems to match a newline followed by a capital A, second I would need to type that our 26 times to get every lowercase letter.
Does anyone know a better way?