Hello everyone.
our trading partner code used to be three characters long. However since the company growth we now using the 4 characters code. How do i filter our all the 1 that have 4 characters.
for example:
tpcode
wal
sam
kma
sams
walm
kmar
Hello everyone.
our trading partner code used to be three characters long. However since the company growth we now using the 4 characters code. How do i filter our all the 1 that have 4 characters.
for example:
tpcode
wal
sam
kma
sams
walm
kmar
How about:
WHERE Len([tpcode]) = 3