HoustonGuy
Programmer
Is there a function that will help me check a field for a repetition of characters in a single field?
Such as:
Field1
-------
AAAAAAAA
00000000
44444444
Currently I use substring to check to see if the first four characters = the last four characters.
If substring(Field1, 1, 4) = Substring(Field1, 5 len(Field1)) then 'All characters match.
Surely there is a function to check this.
Thanks.
Such as:
Field1
-------
AAAAAAAA
00000000
44444444
Currently I use substring to check to see if the first four characters = the last four characters.
If substring(Field1, 1, 4) = Substring(Field1, 5 len(Field1)) then 'All characters match.
Surely there is a function to check this.
Thanks.